Converting Numbers to Dates

[RossSmfc93]

 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 

[#2]

@RossSmfc93 

Excel stores today's date 18 May 2022 as 44699, so you need to add 44699-43 = 44656 to the values.

1. Enter 44656 in a cell.
2. Copy that cell to the clipboard.
3. Select a range with numbers to be converted to dates.
4. 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...
5. Select the Add option button.
6. Click OK.
7. Format the selected range as a date.