Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am looking for a formula that will calculate the number of Mondays
between 2 given dates (date will always be the 23rd of the month). I am currently using =INT((D1-WEEKDAY(D1-1)-C1+8)/7) This is working fine up until it hits a date where the 23rd falls on a Monday. e.g. 23rd Sept 23rd Oct 2008 = 4 Mondays (correct) 23rd Oct 23rd Nov 2008 = 4 Mondays (correct) 23rd Nov 23rd Dec 2008 = 5 Mondays (correct) and so on But when I get to 23rd Jan to 23rd Feb 2009 (which falls on a Monday), Excel is returning 5. I am wanting to see 4 at this point, same for 23rd Feb to 23rd March. How can I amend this formula? 23rd Sept 23rd Oct 2008 = 4 Mondays (correct) 23rd Sept 23rd Oct 2008 = 4 Mondays (correct) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating the number of a Mondays between two dates | Excel Discussion (Misc queries) | |||
Calculate next number using dates? | Excel Worksheet Functions | |||
How do I calculate number of Mondays in a given month in Excel? | Excel Worksheet Functions | |||
calculating number of days (e.g., Mondays) between two dates | Excel Worksheet Functions | |||
number of mondays in period | Excel Discussion (Misc queries) |