# EOWEEK --- similar to EOMONTH

Discussion in 'Microsoft Excel Worksheet Functions' started by Guest, Nov 16, 2006.

1. ### GuestGuest

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

Guest, Nov 16, 2006

2. ### GuestGuest

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

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

Guest, Nov 16, 2006

3. ### David BiddulphGuest

=A1+6-WEEKDAY(A1)
--
David Biddulph

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

David Biddulph, Nov 16, 2006
4. ### GuestGuest

Thanks guys, both solutions work...

Jonathan

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

Guest, Nov 16, 2006