day of Month to Day of Month of Year

[fernandogomes]

Hy to all, its my firts post here. I can't yet, get a solid solution to my problem, so iam asking you guys please help me

OK! I'am using Office 2003 Pro

Let's go to the problem:

I need a formula that give me something like my example:

I give the date: for example 29-10-2008 (day, month, year)

the formula must do the following text:
Weekday 24 of November 2008 to Weekday 30 of November 2008
(the first day of the week to the last day of a week of a given date)

thanks to all......

[DonkeyOte]

assuming A1 holds your date value, in B1:

="Weekday "&TEXT(A1+(1-WEEKDAY(A1,2)),"dd of mmmm yyyy")&" to Weekday "&TEXT(A1+(7-WEEKDAY(A1,2)),"dd of mmmm yyyy")

If in case of say 01 December you want to just display 1 December remove the second of the 2 d references in the text conversions.

[fernandogomes]

DonkeyOte, thanks for your quick reply.

i just forgot to mention that the formulas in my Excel are in Portguese

but iam going to try, thanks....

[fernandogomes]

yeahhhhhhhh


donkey, you made it for me

thank you so much, you saved my day

works just fine

[DonkeyOte]

cool -- there are some translators out there -- you can download this for ex.:

http://puremis.net/excel/cgi-bin/cli...Translator.zip

The above is totally genuine -- no nasties.

[rasonline]

you are probably going to get a request to mark the thread as solved.