Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
similar to sumif() but for averages | Excel Discussion (Misc queries) | |||
Similar to Vlookup | Excel Discussion (Misc queries) | |||
Aligning similar rows | Excel Worksheet Functions | |||
Vlookup on multiple similar entries / NO VBA | Excel Worksheet Functions | |||
How can I delete similar rows in excel workbook with many sheets? | Excel Worksheet Functions |