Forum Discussion
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 appreci...
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)