order of days
On Sat, 15 Nov 2008 15:58:01 -0800, OssieMac
wrote:
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")
Good pickup.
--ron
|