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)
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)
- How many months fall before current date?
- How many months fall after current date, and less than 1x year past (30/09/2017)?
- How many months fall over 1x year past current date, and less than 5x years past current date?
- How many months fall over 5x years past current date?