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
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 ... |
#7
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 |
#8
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? |
#9
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 |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find the length of time (Years & Months) between 2 dates
|
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 |