How to keep a date from changing until a specific time?

**DRFJR** · 10-10-2013, 01:08 PM

Hello
First I want to say thank you for any help you can provide.
I have a report that our night shift fills out and we do not want the date to change until the following day at 8am.
I am using =TODAY() but instead of the date changing at midnight, I need it to stay the same from 8:01am to 7:59am the next day.
How do I set this up?
Thanks

**mehmetcik** · 10-10-2013, 01:41 PM

Please Login or Register  to view this content.

How to keep a date from changing until a specific time?

LinkBack

Thread Tools

Rate This Thread

Display

How to keep a date from changing until a specific time?

Re: How to keep a date from changing until a specific time?

Thread Information

Users Browsing this Thread

Similar Threads

Copy changing data into specific date row

[SOLVED] Changing a date and time to named day, date and rounded down hour

[SOLVED] Changing Multiple sheet names by wk ending date for yr but need specific name/date format

[SOLVED] Show the date and time in a specific cell of last time we run a macro

[SOLVED] Retrieve specific date from one row of one column that is changing

Bookmarks

Bookmarks

Posting Permissions