• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel cell formula to calculate days left on warranty.

W

Winchester

Diamond Member
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?
 
I'll be nice today

=DATE(2005,4,10) - TODAY()

that's for 4/10/2005. Also change the cell format to be "number"
 
Or instead of TODAY() you can use NOW() to get an answer that also uses HH:MM:SS in addition to MM/DD/YY
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top