Need a Days old to Date conversion

M

ml@pok

Hello,
I have a number of days old that I need converted into the date tha
the number originated from.
For instance,
If a unit is 390 days old what date was it received.
Any help will be greatly appreciated.
Thanks.
Marshall Lewi
 
N

Nick Hodge

Marshall

If the days old is in A1 then in B1 type

=Now()-A1

This will need to be formatted as a date

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
G

Gord Dibben

Marshall

Assuming 390 is in A1

In B1 formatted as Date enter =Today()-A1

Gord Dibben Excel MVP
 
Top