Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
a customer supplies sales data on their fiscal week and their weeks run
saturday thru friday midnight and are of the format YYYYWK (200801 thru 200853). the fiscal period starts on first saturday in feb and runs thru last friday in january. is the only way to get the calendar dates for their weeks to set up a lookup table--weeknum() won't work thx reno |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
weeknum | Excel Discussion (Misc queries) | |||
weeknum gone ?? | Excel Worksheet Functions | |||
WEEKNUM | Excel Worksheet Functions | |||
Weeknum | Excel Worksheet Functions | |||
WEEKNUM() | Excel Discussion (Misc queries) |