Quote:
Originally Posted by Zzzato
This is the easiest way to this.
In your first three date cells block erase it, input these values starting at April 1 00:00 -01:00.
Grab the three blocks drag them down to the end and change the format to short date or whatever date format you want. All this is doing is converting the time and date to a serial number and then your converting it back to what you want. |
Thank you, the date doesnt change when it gets to the next 0:00 Time.
I need the date to change when it hits the 0:00 time in Column C, like this (but the same date needs to carry down until the next 0:00 time and then increase the date by 1)