Display "week of July 29" in Excel

[bbcrock]

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.

 

[Roger Govier]

Hi

Try
="Week of "&TEXT(A7-WEEKDAY(A7,2),"mmmm dd, yyyy")

 

[Rubble]

Try this --

=CONCATENATE("Week of ",TEXT(INT(NOW()/7)*7+1,"[$-409]mmmm d;@"))

I used the now() formula for the date you are looking at (so the above
formula today will show "Week of July 22" since we are on the 25th today -
but you could replace the now() with a reference to another date then that
will work for consecutive dates ...

 

[Vergel Adriano]

="Week of " & TEXT(IF(WEEKDAY(A7)=1, A7, A7-WEEKDAY(A7)+1), "mmmm dd, yyyy")