I work at a 24 hour job we take readings every hour. I want to have the date
autofill a cell as the current date but our sheet changes at 0700 every day.
So if the sheet is worked on at 0100 the date needs to be for the past day
starting at 0700, if the time for the current day changes to 0800 the cell
will display the new date. ie:
0100hrs = 4/18/06
0600hrs = 4/18/06
0800hrs = 4/19/06
etc...