Hi,
I know there isn't and EOWEEK function, but there should be :)
I get lots of requests each day and want to run them through reports
showing incoming per week, etc...
So I would like to find an equation that would look at the request date
and then tell me it was requested in the week ending "X".
For example:
Req Date = 11/13/06 week end date = 11/17/06
Req Date = 11/1/06 week end date = 11/3/06
Req Date = 11/27/06 week end date = 12/1/06
etc...
Thanks!
Jon
Ron Coderre - 16 Nov 2006 16:57 GMT
Try something like this:
With
A1: (a date)
This formula returns the Friday day of the week containing A1
B1: =A1-WEEKDAY(A1,2)+5
Weeks run Monday thru Sunday
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
> Hi,
>
[quoted text clipped - 17 lines]
>
> Jon
David Biddulph - 16 Nov 2006 17:01 GMT
=A1+6-WEEKDAY(A1)

Signature
David Biddulph
> Hi,
>
[quoted text clipped - 17 lines]
>
> Jon
Jonathan Horvath - 16 Nov 2006 18:01 GMT
Thanks guys, both solutions work...
Jonathan
> Hi,
>
[quoted text clipped - 17 lines]
>
> Jon