ExcelBanter - formatt to Calculate difference in now() and date in cell,

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

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

- - formatt to Calculate difference in now() and date in cell, (https://www.excelbanter.com/excel-discussion-misc-queries/140652-formatt-calculate-difference-now-date-cell.html)

GARDNERGUY

formatt to Calculate difference in now() and date in cell,

Fred Smith

formatt to Calculate difference in now() and date in cell,

If your date is in A1, use:

=now()-a1

--
Regards,
Fred

"GARDNERGUY" wrote in message
...

All times are GMT +1. The time now is 04:53 PM.