| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find the length of time (Years & Months) between 2 dates
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find the length of time (Years & Months) between 2 dates
One way:
A1: <start date A2: <end date A3: =DATEDIF(A1,A2,"y") & " years, " & DATEDIF(A1,A2,"ym") & " months" See http://cpearson.com/excel/datedif.htm for more documentation on DATEDIF(). In article , David Picken <David wrote: |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find the length of time (Years & Months) between 2 dates
=DATEDIF(date1, date2,"y") for years
=DATEDIF(date1, date2, "ym") for extra months HTH -- AP "David Picken" <David a écrit dans le message de ... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find the length of time (Years & Months) between 2 da
I have a spreadsheet with a date inducted and a date it needs to be replaced.
How do I get a cell with the remaining days between the dates and it update daily? "Ardus Petus" wrote: =DATEDIF(date1, date2,"y") for years =DATEDIF(date1, date2, "ym") for extra months HTH -- AP "David Picken" <David a écrit dans le message de ... |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find the length of time (Years & Months) between 2 da
=DATEDIF(date1, date2,"d") for days between date1 & date2
HTH -- AP "Brandon" a écrit dans le message de ... I have a spreadsheet with a date inducted and a date it needs to be replaced. How do I get a cell with the remaining days between the dates and it update daily? "Ardus Petus" wrote: =DATEDIF(date1, date2,"y") for years =DATEDIF(date1, date2, "ym") for extra months HTH -- AP "David Picken" <David a écrit dans le message de ... |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find the length of time (Years & Months) between 2 da
One way:
A1: <date inducted A2: <date to be replaced A3: =A2-A1 format A3 as General or Number. No idea how to update it daily unless you specify how either of the dates change. In article , Brandon wrote: I have a spreadsheet with a date inducted and a date it needs to be replaced. How do I get a cell with the remaining days between the dates and it update daily? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find the length of time (Years & Months) between 2 dates
Brandon Wrote: I have a spreadsheet with a date inducted and a date it needs to be replaced. How do I get a cell with the remaining days between the dates and it update daily? "Ardus Petus" wrote: =DATEDIF(date1, date2,"y") for years =DATEDIF(date1, date2, "ym") for extra months HTH -- AP "David Picken" <David a écrit dans le message de ... In general to get the difference in days between two dates you only need =B1-A1 where B1 is the later date format as general In your case it looks like you need the difference in days between today and your replacement date - if replacement date in in C1 =C1-today() format as general -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=524789 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find the length of time (Years & Months) between 2 dates
|
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find the length of time (Years & Months) between 2 da
That worked but I worded the problem wrong.
I have a part inducted on 1-1-06 that has a life span of 1825 days. How can I create a formula that will give me the days remaining in a column and have that number updated daily? I'm using Excel 2003. "Ardus Petus" wrote: =DATEDIF(date1, date2,"d") for days between date1 & date2 HTH -- AP "Brandon" a écrit dans le message de ... I have a spreadsheet with a date inducted and a date it needs to be replaced. How do I get a cell with the remaining days between the dates and it update daily? "Ardus Petus" wrote: =DATEDIF(date1, date2,"y") for years =DATEDIF(date1, date2, "ym") for extra months HTH -- AP "David Picken" <David a écrit dans le message de ... |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find the length of time (Years & Months) between 2 dates
=1825+DATE(2006,1,1)-TODAY() format as general -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=524789 |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find the length of time (Years & Months) between 2 da
1745
"daddylonglegs" wrote: =1825+DATE(2006,1,1)-TODAY() format as general -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=524789 |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find the length of time (Years & Months) between 2 da
It returned 1745
"Brandon" wrote: 1745 "daddylonglegs" wrote: =1825+DATE(2006,1,1)-TODAY() format as general -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=524789 |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find the length of time (Years & Months) between 2 dates
Is that not correct? You wanted the days remaining. If it shows 1745 today it will show 1744 tomorrow and so on until it reaches zero on 31st December 2010. -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=524789 |
|
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find the length of time (Years & Months) between 2 da
Well of course had I closed the application and reopened it and used my
brain. Thank you so much for all the help. It seems to work like a charm. I will try it on the main sheet and see what happens. This has been very helpful. "daddylonglegs" wrote: Is that not correct? You wanted the days remaining. If it shows 1745 today it will show 1744 tomorrow and so on until it reaches zero on 31st December 2010. -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=524789 |
|
#15
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find the length of time (Years & Months) between 2 da
Does the 360 days a year affect the calculations? I saw where Excel uses 360
days in the year instead of 365. "daddylonglegs" wrote: Is that not correct? You wanted the days remaining. If it shows 1745 today it will show 1744 tomorrow and so on until it reaches zero on 31st December 2010. -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=524789 |
|
#16
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find the length of time (Years & Months) between 2 dates
Using the formula I posted the calculation will be correct. There is a DAYS360 function in Excel which uses a 360 day year for accounting purposes but, other than that Excel will calculate using 365 day or 366 day years as appropriate -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=524789 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to calculate years, months by using one formula | Charts and Charting in Excel | |||
| difference between two dates in years, months and days. | Excel Worksheet Functions | |||
| calculate date differences in years and months | Excel Worksheet Functions | |||
| How to calculate time between two dates? | Setting up and Configuration of Excel | |||
| Converting months to years | Excel Worksheet Functions | |||
Linear Mode
