Count Months in a Range, before, after and between set dates

Odette

New member
Joined
Sep 14, 2016
Messages
5
Reaction score
0
Points
0
Hi everyone,
I am hoping for some help with formulas for the following 4x scenarios – Please! I have tried, without success.

Current Date: 30/09/2016 (cell B2)
Date Range: 01/12/2015 (cell C6) to 30/11/2021 (cell D6)



  1. How many months fall before current date?
  2. How many months fall after current date, and less than 1x year past (30/09/2017)?
  3. How many months fall over 1x year past current date, and less than 5x years past current date?
  4. How many months fall over 5x years past current date?
 

Attachments

  • Date Formula Help Request Sept16.xlsx
    11.5 KB · Views: 4
Yes it is. Apologies if this is not acceptable, but as it appeared that only 1x of my questions was answered which wasn't any of the 4x listed above, I thought that anyone looking at my question would not realize that these had not been answered. Sorry.
 
It's OK. In the future if you need to do it again, just add a link to the previous post. As I already did, no worries.
 
Back
Top