Date - formula

D

dmeconi

I need to write a formula to put the current date on a document however, if
it is between 1am and 4am when it is written, I want it to retain the date of
the day before.

Suggestions?
 
F

Frank Kabel

Hi
I would assume you meant between 00:00 and 04:00?. If yes try:
=TODAY()-(MOD(NOW(),1)<=4/24)
 
Top