View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GEM GEM is offline
external usenet poster
 
Posts: 90
Default Identifing Weeks in a Month.

I have this function,

=TEXT(TODAY()-WEEKDAY(NOW(),3),"mmmm d, yyyy")&" -
"&TEXT(TODAY()-WEEKDAY(NOW(),3)+6,"mmmm d, yyyy")

It identifies the week we are currently in starting on Monday by giving me
the result "July 27, 2009 - August 2, 2009"

How can I insert a function on different cells which give me the first,
second, third, and forth week of the month?? For example for this month,

A1=June 29, 2009 - July 5, 2009
A2=July 6, 2009 - July 12, 2009
A3=July 13, 2009 - July 19, 2009
A4= July 20, 2009 - July 26, 2009
A5=July 27, 2009 - August 2, 2009