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.

Hi

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

--
Regards
Roger Govier



<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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.
>

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 ...

"(E-Mail Removed)" wrote:

> 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.
>
>

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


--
Hope that helps.

Vergel Adriano


"(E-Mail Removed)" wrote:

> 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.
>
>