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 ...
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.