| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Count
Hi all ...
I would like to know if Excel can count the number of Years and Months for a duration (E.g from 1 Jan 2005 to 1 Dec 2006). With a formula set, it gives you the answer as 1 Year 11 months. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Count
=DATEDIF(A1,A2,"y") & " years, " & DATEDIF(A1,A2,"ym") & " months, " &
DATEDIF(A1,A2,"md") & " days" if the dates are in A1 and A2 -- Gary's Student gsnu200701 "SgMike" wrote: Hi all ... I would like to know if Excel can count the number of Years and Months for a duration (E.g from 1 Jan 2005 to 1 Dec 2006). With a formula set, it gives you the answer as 1 Year 11 months. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count number of occurences on a particular date | Excel Worksheet Functions | |||
| Count items when specific text and date criteria are met | Excel Worksheet Functions | |||
| How do I count the number of days from 1 date to another? | Excel Discussion (Misc queries) | |||
| count the number of cells within a column with a date <= today's d | New Users to Excel | |||
| count the number of cells with a date <= today's date | New Users to Excel | |||
Linear Mode
