Hi all,
I've been given a sheet with approximately 25 cells that have 2 dates in each cell as serial numbers, and I'm trying to figure out how to quickly convert them to short/long dates.
Right now I'm doing it manually, where I copy-paste the serial into a date formatted cell, which returns the date, and then copy-paste that result back. I'm wondering if there's a smarter or more automated way I can accomplish this, especially considering there's a shape (arrow) involved as well.
E.g.:
Many thanks!
I've been given a sheet with approximately 25 cells that have 2 dates in each cell as serial numbers, and I'm trying to figure out how to quickly convert them to short/long dates.
Right now I'm doing it manually, where I copy-paste the serial into a date formatted cell, which returns the date, and then copy-paste that result back. I'm wondering if there's a smarter or more automated way I can accomplish this, especially considering there's a shape (arrow) involved as well.
E.g.:
Many thanks!