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