Count after an interval of days.

Copper Contributor

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.

3 Replies

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.