Forum Discussion
Solved
Calculate number of days, within a date range, that touch a specified month (or other period)
Hello, I would like to know if a formula can be used to calculate the number of days, within a specified range that ALSO fall within a specific month (or "other" specified period) See the examp...
=MAX(MIN(C$3,$B4)-MAX(C$2,$A4)+1,0)You can try this formula with the layout of the example which doesn't have merged cells and the dates in rows 2 and 3 are easier to reference.
=MAX(MIN(C$3,$B4)-MAX(C$2,$A4)+1,0)You can try this formula with the layout of the example which doesn't have merged cells and the dates in rows 2 and 3 are easier to reference.
OliverScheurich Thank you! That worked perfectly!