Excel cell formula to calculate days left on warranty.

[Winchester]

I am creating a excel spreadsheet that has all our server info on it, about 70. I would like the remaining warranty to update to be current every time someone opens the file.

Any ideas?

 

[Traire]

Well, if its a fixed date you could do

=date(year, month, day)-today()

Will give you a number counting down from the fixed date assuming the warranty date is in the future

Or if you have cells that have the warranty date, then do the same thing just replace the date tag to point to the cell with the warranty date like:

=B4-today()

B4 is the cell with your warranty date, just set the cell that you want the countdown in to be formated as a number instead of a date

 

[Concillian]

=Date(year,month,day) - now()

example:
=DATE(2005,3,15)-NOW()

Edit: Too late! I am slow

 

[Winchester]

Thanks guys. Very helpful.

 

[Traire]

And just for more FYI

The "now()" tag also includes time information, as well as date. The "today()" tag just has date information. Either would work for what you want to do. If you use the "now()" tag, you will get a decimal, like 65.23, since it is actually calculating down to the second. If you use the "today()" tag, you will get a whole number of just days.

 

[mhillary]

Originally posted by: Concillian
=Date(year,month,day) - now()

example:
=DATE(2005,3,15)-NOW()

Edit: Too late! I am slow

This is a good one