derek_e2015
New Member
- Joined
- May 18, 2021
- Messages
- 7
- Office Version
- 2019
- Platform
- Windows
Looking to see if there is a way using a macro to change the date in a column to the previous day. there is a column in this a worksheet that is formatted as follows: 4/5/2019 2:40 AM
If the time is between 12:00 AM and 3:00 AM I need the date to be changed to the previous day. So for the example above, it needs to be
4/4/2019 2:40 AM
I have a list of items that I really don't want to have to search through to find the times between 12am and 3am and manually change the date. was hoping there was a way to write up a macro to do this
thank you
If the time is between 12:00 AM and 3:00 AM I need the date to be changed to the previous day. So for the example above, it needs to be
4/4/2019 2:40 AM
I have a list of items that I really don't want to have to search through to find the times between 12am and 3am and manually change the date. was hoping there was a way to write up a macro to do this
thank you