Calculating dates

  • Thread starter Thread starter bonnie
  • Start date Start date
B

bonnie

Hi,

Can you calculate how many months and days are in between
to dates. ie

11/1/1993 thru 3/1/2004

Help :0)
 
=DATEDIF(A1,B1,"m")&" month(s) and "&DATEDIF(A1,B1,"md")&" day(s)"

where A1 is start date and B1 end date
 
Hi
you may use DATEDIF:
=DATEDIF(A1,A2,"m") & "months and " & DATDIF(A1,A2,"md") & " days"
 
Hi Bonnie!

Peo, Frank and the self-effacing Harald have given you an answer but
you need to be aware that the lack of a constant number of days in a
month can produce weird looking (even if correct) answers:

A1:
31-Jan-2004
B1:
1-Mar-2005
C1:
=DATEDIF(A1,B1,"m")&" month(s) and "&DATEDIF(A1,B1,"md")&" day(s)"
Returns: 13 month(s) and -2 day(s)

The only way around this is to use a constant measurement like days
(use =A1-B1 ) or weeks.

=INT((B1-A1)/7)& " Weeks"
Returns: 56 Weeks.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top