View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] bbcrock@gmail.com is offline
external usenet poster
 
Posts: 2
Default Display "week of July 29" in Excel

I followed examples to display all dates in a given week as "Week 26"
or "Week 31" but would like to modify the date so it reads "Week of
July 29, 2007."

the formula I'm using looks like this:

=TRUNC(((A7-DATE(YEAR(A7),1,1))/7))+1+IF(WEEKDAY(DATE(YEAR(A7),
1,1))WEEKDAY(A7),1,0)

thanks for any help!

I would like to stick to something easier rather than more complex if
such a solution exists.