Hi,
I'm trying to determine a formula that could be used to calculate the the number of specific days (i.e Mondays, Tuesdays) in each month (i.e January, February) using a date range. The date range will always be within the same year. The table that I have been trying to code (without macros) is shown below.
Would appreciate any assistance.
Many thanks,
Sam
<tbody>
</tbody>
I'm trying to determine a formula that could be used to calculate the the number of specific days (i.e Mondays, Tuesdays) in each month (i.e January, February) using a date range. The date range will always be within the same year. The table that I have been trying to code (without macros) is shown below.
Would appreciate any assistance.
Many thanks,
Sam
Start Date | End Date | ||||
20/01/2014 | 20/04/2014 | ||||
Monday | Tuesday | Wednesday | Thursday | Friday | |
January | =? i.e Count the number of Mondays in January within the date range above | ||||
February | |||||
March | |||||
April | |||||
May | |||||
June | |||||
July | |||||
August | |||||
September | |||||
October | |||||
November | |||||
December |
<tbody>
</tbody>