Number of days in a fiscal year

**managingcrap** · 10-01-2016, 05:40 PM

I'm looking for a function that will allow me to know how much days in a fiscal year there is covered under a date range.

For example in my sheet, I have fiscal year 2016 with start date on 10/1/2015 (cell B2) and end date on 09/30/2016 (cell C2). I have a date range of 01/01/2015 (B4) and 01/01/2016 (C4). The result is in cell B6.

What I am trying to find out is a function that will show me HOW MANY DAYS in 01/01/2015 - 01/01/2016 fall under 10/01/2015 - 09/30/2016. In the example, the number of days is 92 days.

Thanks in advance for your help.

**Tony Valko** · 10-01-2016, 06:21 PM

Try this...

=MAX(0,MIN(C2,C4)-MAX(B2,B4))

**joris moerings** · 10-03-2016, 04:40 AM

The outcome of your example (and biff's answer for that matter) has me confused.

Yes, the outcome of Biff's formula is 92 days but the number of overlapping days from my point of view is 93.
I asume it has something to do with missing to count the first- and last day of the period.

My formula would be =MAX(0,MIN(C2,C4)-MAX(B2,B4)+1)

did i miss or overlooked something ?

**Tony Valko** · 10-03-2016, 07:59 AM

Originally Posted by joris moerings

Yes, the outcome of Biff's formula is 92 days but the number of overlapping days from my point of view is 93.

My formula would be =MAX(0,MIN(C2,C4)-MAX(B2,B4)+1)

That's the formula/outcome I got but I removed the +1 as the OP said they expected the result to be 92.

Number of days in a fiscal year

LinkBack

Thread Tools

Rate This Thread

Display

Number of days in a fiscal year

Re: Number of days in a fiscal year

Re: Number of days in a fiscal year

Re: Number of days in a fiscal year

Thread Information

Users Browsing this Thread

Similar Threads

Calculate week number for Fiscal Year Dates

[SOLVED] Trying to return the week number of dates in a fiscal year

Calculate week number for Fiscal Year Dates

Number to Fiscal Year Date?

[SOLVED] Need to count business days in a date range with results grouped by fiscal year

how to convert date to fiscal year if fiscal year start at 16th or 17th of July

[SOLVED] Macro to Return Net Work Days by Fiscal Year

Calculating the Quarter Number for Calendar and Fiscal Year

Bookmarks

Bookmarks

Posting Permissions