EXCEL Vs. Time Left
March 25, 2011 9:37 AM Subscribe
Excel Question! I have two dates on my spreadsheet. How can I accurately determine (retrieve) the time remaining on a warranty date.
posted by TeachTheDead to Computers & Internet (9 answers total)
This has been a nightmare here at the office and none of us are Excel guru's.
We have a date of instal for something. Lets say the customer has 2 years until that service falls out of warranty. We need Excel to see the
=NOW() - for the current day of course, and the cell that has the date of service, say July 12th 2009. How can we show in the workbook how many months remain until the warranty is expired.
I have tried several variations using the DATEDIF function, but can only, obviously get different forms of the date differences. I need there to be a base of 2 years, 24 months whatever and subtract that from the current date =NOW() to give the customer the final months remaining based on the date of instal/service.
Please help us here, this has to be doable.
We are running Excel 2007