Archive of Mr Excel Message Board
Back to Dates in Excel archive index
Back to archive home
Calculating the differencfe in days between two dates
Posted by Sarah Powell on March 14, 2001 2:04 AM
How do I calculate the differnence in days between two dates?
Re: Calculating the differencfe in days between two dates
Posted by Aladin Akyurek on March 14, 2001 3:38 AM
In C1 enter: =B1-A1
where A1 and B1 contains your dates. Format C1 as general.
Aladin
Re: Calculating the differencfe in days between two dates
Posted by Dave Hawley on March 14, 2001 7:23 AM
Aladin, there is an Excel Function for this
=DATEDIF(A1,B1,"d")
It will aslo take "m", "Y" etc
Dave
OzGrid Business Applications
Re: Calculating the differencfe in days between two dates
Posted by Aladin Akyurek on March 14, 2001 7:56 AM
Yes Dave, I know. I chose a form that is informative. That dates are jusl like numbers to which oordinary maths ops also apply.
Aladin , there is an Excel Function for this
Sorry, just trying to help!
Posted by Dave Hawley on March 14, 2001 8:17 AM
OzGrid Business Applications
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.