order of days
The above formulas are not correct for all occurrences. They do not work
where the particular days are multiples of 7. Examples are Mondays in
January, April and July 2008 where Mondays are 7, 14, 21 and 28.
However, replacing the Int function +1 with Roundup appears to solve the
problem.
=ROUNDUP(DAY(A1)/7,0)&" "&TEXT(A1,"dddd"&" of "&"mmmm yyyy")
=INDEX({"First","Second","Third","Fourth","Fifth"} ,ROUNDUP(DAY(A1)/7,0))&"
"&TEXT(A1,"dddd"&" of "&"mmmm yyyy")
--
Regards,
OssieMac
"Ron Rosenfeld" wrote:
On Sat, 15 Nov 2008 06:18:50 -0800 (PST), Totti
wrote:
Thank you very much both,
Ron yours work great.
You're welcome. I see now that mine is pretty much the same as muddan, except
I added a "translation" from "1" to "First" and so forth.
--ron
|