Home

Count after an interval of days.

GeoGRG
New 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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies