Calculate days of each month in a range date in Excel Formula
I have sets of date range that I need to calculate total number of days. but usually the start of the range and the end is during the middle of the month.
So how do I calculate number of days of each month.