Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conversion needed
I need to convert a number of days into years, months, days format. An idea? I put the first start date in A10 and the first end date in A11 The second set up dates are in B10 and B11 respectively. I used thi formula to get the number of days in between each start and end date. =DATEDIF(A10,A11,"d") =DATEDIF(B10,B11,"d") And then combined them as... =SUM(DATEDIF(A10,A11,"d")+DATEDIF(B10,B11,"D")) But now I need to switch back and get the total of # Years, # Months #Days -- juster2 ----------------------------------------------------------------------- juster21's Profile: http://www.excelforum.com/member.php...fo&userid=2539 View this thread: http://www.excelforum.com/showthread.php?threadid=39138 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
conversion needed
See www.cpearson.com/excel/datedif.htm for examples of how to do
this with the DATEDIF function. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "juster21" wrote in message ... I need to convert a number of days into years, months, days format. Any idea? I put the first start date in A10 and the first end date in A11. The second set up dates are in B10 and B11 respectively. I used this formula to get the number of days in between each start and end date. =DATEDIF(A10,A11,"d") =DATEDIF(B10,B11,"d") And then combined them as... =SUM(DATEDIF(A10,A11,"d")+DATEDIF(B10,B11,"D")) But now I need to switch back and get the total of # Years, # Months, #Days. -- juster21 ------------------------------------------------------------------------ juster21's Profile: http://www.excelforum.com/member.php...o&userid=25393 View this thread: http://www.excelforum.com/showthread...hreadid=391382 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Rows With Non-Needed Data between Needed Data | Excel Worksheet Functions | |||
Date Conversion Formula Needed | Excel Worksheet Functions | |||
Between conversion | Excel Worksheet Functions | |||
Conversion of VBA to VB.Net | Excel Programming | |||
XLS to CSV conversion | Excel Programming |