Need a Days old to Date conversion

[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

 

[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
(e-mail address removed)

 

[Gord Dibben]

Marshall

Assuming 390 is in A1

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

Gord Dibben Excel MVP