'Excel to have the current date be "tomorrow" at a certain time
Trying to get excel to update the "working date" at 8PM which would allow the date to be tomorrow until 12AM at which point it would remain today until 8PM.
''' =IF(TIME("08:00:00 PM")>=, [TODAY()+1], [TODAY()]) '''
or
''' =IF(NOW()>=TIME(20,0,0), [TODAY()+1], [TODAY()]) '''
Granted neither of these work right now.
Syntax Errors, unsure where.
I bow to intellects far greater and superior than mine.
Solution 1:[1]
NOW returns a date and time. The date is an integer number. If you substract the integer you het the time.
IF(NOW()-INT(NOW)>=TIME(20,0,0),TODAY()+1,TODAY())
Note that it will only update if a (any) change is made within the sheet (or on opening the file).
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | P.b |