EOWEEK similar to EOMONTH....
 

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

EOWEEK similar to EOMONTH....
 

try something like this
=A1-WEEKDAY(A1)+6

fiddle around with it a bit to get it how you want.
--
Allllen


"Jonathan Horvath" wrote:

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

EOWEEK similar to EOMONTH....
 

Please don't multi-post. Cross-post if you must.
Answer is in the other group.
--
David Biddulph

"Jonathan Horvath" wrote in
message ...
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