View Single Post
Old 10-19-2017, 06:29 PM   #4
Zzzato
Bigg Balls
 
Zzzato's Avatar
 
Drives: 2024 Red Hot 1SS
Join Date: Jul 2017
Location: SLC
Posts: 164
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.
Attached Images
 
__________________
2017 Red Hot 1SS 8A..... Sold for a minivan
2024 Red Hot 1SS 8A.... No mods ..... yet
Zzzato is offline   Reply With Quote