| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating the number of a Mondays between two dates
Is there a function which can calculate the number of a specified weekday
between two dates? e.g. How many Mondays there are between 01/07/08 and 01/08/08? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating the number of a Mondays between two dates
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))=2))
"AChua" wrote: Is there a function which can calculate the number of a specified weekday between two dates? e.g. How many Mondays there are between 01/07/08 and 01/08/08? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating the number of a Mondays between two dates
On Thu, 24 Jan 2008 16:16:20 -0800, AChua
wrote: Is there a function which can calculate the number of a specified weekday between two dates? e.g. How many Mondays there are between 01/07/08 and 01/08/08? In general: =INT((A2-WEEKDAY(A2+1-DOW)-A1+8)/7) Where A2: End Date A1: Start DAte DOW: Day of week (Sun=1, Mon=2, ...) --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate number of Mondays in a given month in Excel? | Excel Worksheet Functions | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| Calculating number of weeks from two dates | Excel Discussion (Misc queries) | |||
| calculating number of days (e.g., Mondays) between two dates | Excel Worksheet Functions | |||
| number of mondays in period | Excel Discussion (Misc queries) | |||
Linear Mode
