G
Guest
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
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