John,
in cell A1 type in =NOW()
in cell B1 type in the date that you want to subtract from, say 1/1/2002
in cell C1 type =b1-a1 and you will get the number of days from today till that date. The fraction you get can be converted into hours. If you want just change format to show whole numbers...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.