How do I count days between 2 dates but break them out by month. For example. 9/30-10/1. This is a c

Pmumphrey

How do I count days between 2 dates but break them out by month. For example. 9/30-10/1. This is a count of 2 days but i want to capture it as 1 day in October and 1 day on September

KPH

I do this using 4 IF formulas and add them together.

IF date range starts before 1st and ends before last day of month, calculate days between 1st and end.

IF date range starts after 1st and ends before last day of month, calculate days between start and end.

IF date range starts before 1st and ends after last day of month, calculate days in month.

IF date range starts after 1st and ends after last day of month, calculate days between start and last day of month.

Adding these 4 together will give you the days in the month.

To make it easier you probably want to make the month a reference another cell so that you aren't adding the month in the formula multiple times and can reuse the formula for any month. Or you could set up another sheet where you define the start and end of each period and refer to that.