AXISHK
asked on
Date Calculation in Excel
There is a purchase date column in a Excel. Is it possible to write a formula such that is the purchase date - today is more than 3 years. A message "out of warranty" will be displayed.
Tks
Tks
See attached
date.xlsx
date.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It might be safer to use 1096 to take account of possible leap years
or use Rory Archibald's formula.
or use Rory Archibald's formula.
I am on my way back to home so can't help it now. Surly assist you after 2 hours to how to tackle leap year.
Thanks
Thanks
But I guess Mr.Rory Archibald's Formula is more appropriate than mine.
Thanks
Thanks
ASKER
tks
Open in new window