Forum Discussion
Converting Numbers to Dates
Hi,
I have hundreds of spreadsheets where I need to convert numbers to dates. For example, in the photograph, I need to convert number 43 to todays date (18 May 2022). The days count back so number 42 will be yesterdays date (17 May 2022). I have been working on this by using find and replace to replace all the relevant numbers to date but takes a huge amount of time. Is anyone aware of any alternative?
Many thanks
Excel stores today's date 18 May 2022 as 44699, so you need to add 44699-43 = 44656 to the values.
- Enter 44656 in a cell.
- Copy that cell to the clipboard.
- Select a range with numbers to be converted to dates.
- Click the lower part of the Paste button on the Home tab of the ribbon and select Paste Special..., or right-click in the selected range and select Paste Special...
- Select the Add option button.
- Click OK.
- Format the selected range as a date.
