IF statement Help

[John G]

Is there a way I can do the following to force a date
change according to a certain time. In cell b5 I have =Now
(), and that returns todays date. If the time is between
midnight and six am I would like the date to go back one
day, such as =Now()-1.

Even if I have to make a button to run macro that would
be OK. I just can't figure out the IF statement that
would compare the times.

I want it to read something like this; if the time is
between 00:00:00 and 06:00:00 then Now()-1 else Now()

Thanks in advance for your help

John G

 

[GJones]

John;

Create a macro that contains:

If hour(now)<6 then Range("A1") = Date -1

Else Range("A1") = Date

End If

 

[Tom Ogilvy]

=IF(HOUR(NOW())<6,NOW()-1,NOW())

 

[John G.]

Thank You very much for the reply Tom & GJones

-----Original Message-----
=IF(HOUR(NOW())<6,NOW()-1,NOW())

--
Regards,
Tom Ogilvy




.