| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
EOWEEK --- similar to EOMONTH
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
EOWEEK --- similar to EOMONTH
=A1+6-WEEKDAY(A1)
-- 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
EOWEEK --- similar to EOMONTH
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EOWEEK similar to EOMONTH.... | Excel Discussion (Misc queries) | |||
| conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
| Aligning similar rows | Excel Worksheet Functions | |||
| I'm Having Problems with EOMONTH | Excel Worksheet Functions | |||
| I'm having problems with EOMONTH | Excel Worksheet Functions | |||
Linear Mode
