If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
what formula to get how longer from date
if (B2 is 01 April 2006) and (B3 is 31/05/2009), what formula can i use to
get how long in between this two date? |
#2
|
|||
|
|||
what formula to get how longer from date
If those values are really dates, then you can use:
=b3-b2 (and format as General) to get the number of days between the dates. If you want years, months, days, then look at Chip Pearson's site: http://www.cpearson.com/excel/datedif.aspx ykn wrote: if (B2 is 01 April 2006) and (B3 is 31/05/2009), what formula can i use to get how long in between this two date? -- Dave Peterson |
#3
|
|||
|
|||
what formula to get how longer from date
Use
=Datedif(Beginning Date,Ending Date,"D") for calculating difference in days, =Datedif(Beginning Date,Ending Date,"M") for calculating difference in months, =Datedif(Beginning Date,Ending Date,"Y") for calculating difference in years. "ykn" wrote: if (B2 is 01 April 2006) and (B3 is 31/05/2009), what formula can i use to get how long in between this two date? |
#4
|
|||
|
|||
what formula to get how longer from date
Hi,
the main problem with DATEDIF is Microsoft doesn't document it (except in version 2000). But in your case Dave's solution is shorter. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "FARAZ QURESHI" wrote: Use =Datedif(Beginning Date,Ending Date,"D") for calculating difference in days, =Datedif(Beginning Date,Ending Date,"M") for calculating difference in months, =Datedif(Beginning Date,Ending Date,"Y") for calculating difference in years. "ykn" wrote: if (B2 is 01 April 2006) and (B3 is 31/05/2009), what formula can i use to get how long in between this two date? |
Thread Tools | |
Display Modes | |
|
|