Jan 26 2019 11:28 AM - edited Jan 26 2019 11:38 AM
Hi, i do need an formula that can count days after an interval of 30 days between 2 dates.
Date A: December 1st
Date B: January 1st
Number of days after 30 days today: 27
Thank you.
Jan 26 2019 11:51 AM
Sorry, but I didn't catch what exactly means counting after the interval. After the last date in interval?
In general dates in Excel are just integer, as an example
=TODAY()-DATE(2019,1,1)
returns 25 of today is Jan 26, 2019
Jan 26 2019 12:04 PM
I do have a term of 30 days, from date A to date B. I want to know how many delayed days are today after that term.
Jan 26 2019 02:17 PM
That will be
=TODAY()-B1
if date B is in cell B1.