ExcelBanter - date converted to days

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - date converted to days (https://www.excelbanter.com/excel-discussion-misc-queries/202566-date-converted-days.html)

wilecoyote

date converted to days

I am looking for a formula to convert a opening date of a corrective action
to the number of days the corrective action has bee open.
--
wilecoyote

Gary''s Student

date converted to days

With the date in A1, use
=TODAY()-A1 and format as general
--
Gary''s Student - gsnu200805

David Biddulph[_2_]

date converted to days

=TODAY()-A2
--
David Biddulph

"wilecoyote" wrote in message
...
I am looking for a formula to convert a opening date of a corrective action
to the number of days the corrective action has bee open.
--
wilecoyote

All times are GMT +1. The time now is 11:53 AM.