charliehickman0923
New Member
- Joined
- Dec 21, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I can't find an answer to this question, sorry if it's buried somewhere in threads.
I want to just change the date in a cell without changing the time: EX: my cell looks like this but with different times: 12/29/2020 07:00 . I want to change to 01/05/2021 07:00 I only want to change the date in each cell and not the time.
The only way I found to use the Replace function is when the cell has a text format. My format is a custom format: mm/dd/yyyy hh:mm so the replace function doesn't find any matches.
does this make sense, and is there an easy way to do this that I'm missing?
THANK YOU!
I want to just change the date in a cell without changing the time: EX: my cell looks like this but with different times: 12/29/2020 07:00 . I want to change to 01/05/2021 07:00 I only want to change the date in each cell and not the time.
The only way I found to use the Replace function is when the cell has a text format. My format is a custom format: mm/dd/yyyy hh:mm so the replace function doesn't find any matches.
does this make sense, and is there an easy way to do this that I'm missing?
THANK YOU!