PC Review


Reply
Thread Tools Rate Thread

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

 
Reply With Quote
 
 
 
 
=?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
>

 
Reply With Quote
 
 
 
 
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
>



 
Reply With Quote
 
=?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
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
EOWEEK similar to EOMONTH.... =?Utf-8?B?Sm9uYXRoYW4gSG9ydmF0aA==?= Microsoft Excel Misc 2 16th Nov 2006 07:02 PM
eomonth funciton in VBA ExcelMonkey Microsoft Excel Programming 2 11th Feb 2004 05:25 PM
Is there an End of Week function similar to the EOMONTH? Chris Microsoft Excel Worksheet Functions 1 23rd Jan 2004 07:08 PM
Similar hard drive - not similar behaviour shuffle Storage Devices 0 26th Nov 2003 05:01 PM
Merging two similar but not-so-similar workbooks DiscoJason Microsoft Excel Misc 1 20th Nov 2003 07:38 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:34 AM.