Forum Discussion

Mathew Bauler's avatar
Mathew Bauler
Copper Contributor
Mar 30, 2018

Need formula to exclude date and time over 24 hours out.

I'm making a formula that takes date and time, e.g. "3/31/2018  02:00:00" and only counts it if it if it's 24 hours or more in the future from the CURRENT time in real time. Any help would be appreciated.

excel
Formulas and Functions

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 31, 2018

    Hi Mathew,

     

    you may compare with NOW()+1 which is 24 hours ahead from current date and time. For example, if you have the range with dates and times to calculate how many meet the condition

    =COUNTIF(youRange,">="&NOW()+1)