Forum Discussion
Count after an interval of days.
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.
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
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.
That will be
=TODAY()-B1
if date B is in cell B1.