Excel date Question

[willi19]

I am new to using excel and need a little help. I have this formula =TODAY() for todays date which changes at 12am. Is there any way that I can make it so the date would change to the next day at 6pm instead of 12am?

 

[ottasight]

hi
try this =IF((NOW()-TODAY())>=0.75,(TODAY()+1),TODAY())

 

[shg]

Or similarly,

=TODAY() + (MOD(NOW(), 1) >= --"18:00")

 

[barry houdini]

...or even....

=INT(NOW()+"6:00")

 

[willi19]

Thanks guys, for the fast response. Suggestions worked good.