Back-Dating Problem

[Aviles]

Hi all,

I have cell on a workbook that shows the current system date (dd/mm/yyyy), and I'm looking for a formula that will amend the date depending on the time of day it is. Naturally, when the time moves past 12am, the system date clicks over to the next day.

What I would like is a formula that will only change the date after 9am the following day. So between 12am-9am I want the date in that cell to revert back to the previous date (i.e. I don't want the date to change until after 9am).

Can any one help with this please?

 

[Gerald Higgins]

How are you displaying the date ?
One way would be to use the =NOW() function formatted as date, and not showing the time.

If you are using NOW(), then you can do something like this

=NOW()-9/24

 

[Aviles]

Thanks Gerald, that worked great!