Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for a date's week number in a month (1st, 2nd, etc.)
i.e. If today is 3/10/06, it falls in the 2nd week of March. Is there a way
to calculate this in a formula? (Also, will there a be a problem where a date like 3/1/06 falls under the week 5 of February as wells as week 1 of March?) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function or formula to convert "text" month to number of month? | Excel Discussion (Misc queries) | |||
Function or formula to convert "text" month to number of month? | Excel Discussion (Misc queries) | |||
Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
Formula to count number of dates in an array | Excel Worksheet Functions | |||
Returning the Week Number of a Specific Date on a Month | Excel Worksheet Functions |