Thread
:
Which day
View Single Post
#
4
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Which day
Looks good and if you really want to get fancy
4thThursday of March
=INT((DAY(G10)-1)/7)+1& CHOOSE(INT((DAY(G10)-1)/7)+1,"st","nd","rd","th")&
TEXT(G10,"dddd")& " of "& TEXT(G10,"mmmm")
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Peter T" <peter_t@discussions wrote in message
...
=INT((DAY(A1)-1)/7)+1
But I fear that's too obvious and I'm missing something!
Regards,
Peter T
"geebee" (noSPAMs) wrote in message
...
Hi,
I need to write something which determines whether or not the day is the
first, second, third or fourth day. For example if it is Thursday,
determine
whether or now its the first, second, third or fourth Thursday of the
month.
Thanks in advance,
geebee
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett