Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count left over days with date
Hello,
I would like to have a count down of left over days in reference to a warranty date. In my file I have column G that has a date in day/month/year format and in the column H I would like to have an automatic count down of months left. The contracts has 3 years, so that means 36 months. Thank you so much for your help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count left over days with date
Have a look at the DATEDIF function, explained here on Chip Pearson's
site: http://www.cpearson.com/excel/datedif.aspx Compare the date in column G with TODAY(), and get the answer in months (if that's what you want). Hope this helps. Pete On Apr 15, 3:06*pm, Pascale wrote: Hello, I would like to have a count down of left over days in reference to a warranty date. In my file I have column G that has a date in day/month/year format and in the column H I would like to have an automatic count down of months left. The contracts has 3 years, so that means 36 months. Thank you so much for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to count days between two dates including start date | Excel Worksheet Functions | |||
Count number of days between dates BUT IF null to current date | Excel Worksheet Functions | |||
How do I count the number of days from 1 date to another? | Excel Discussion (Misc queries) | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Count-down timer? (e.g. 10 days left...9...8...) | Excel Discussion (Misc queries) |