| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
count the days between 2 dates and convert
Hi, I have the following in data in cells and I want to calculate the days
between 2 date, which I can do, it returns 2316 days. cell A1 is 30/04/2001 cell A2 is =Today() cell A3 =SUM(A2-A1) returns 2316 days I need to convert this figure into Years, Months and Days. e.g. 6 years 4 months and 3 days. Does anyone have any idea on a formula for this? Regards MN |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count of days between dates | Excel Discussion (Misc queries) | |||
| Count days inside 2 dates | New Users to Excel | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| convert dates to number of days | Excel Worksheet Functions | |||
| count days between dates | Excel Programming | |||
Threaded Mode
