# EOWEEK --- similar to EOMONTH

=?Utf-8?B?Sm9uYXRoYW4gSG9ydmF0aA==?=
Guest
Posts: n/a

 16th Nov 2006
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

=?Utf-8?B?Um9uIENvZGVycmU=?=
Guest
Posts: n/a

 16th Nov 2006
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
>

David Biddulph
Guest
Posts: n/a

 16th Nov 2006
=A1+6-WEEKDAY(A1)
--
David Biddulph

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

=?Utf-8?B?Sm9uYXRoYW4gSG9ydmF0aA==?=
Guest
Posts: n/a

 16th Nov 2006
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
>

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post =?Utf-8?B?Sm9uYXRoYW4gSG9ydmF0aA==?= Microsoft Excel Misc 2 16th Nov 2006 07:02 PM ExcelMonkey Microsoft Excel Programming 2 11th Feb 2004 05:25 PM Chris Microsoft Excel Worksheet Functions 1 23rd Jan 2004 07:08 PM shuffle Storage Devices 0 26th Nov 2003 05:01 PM DiscoJason Microsoft Excel Misc 1 20th Nov 2003 07:38 PM

Features