| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
difference between dates
Hi,
I am using this formula to calculate the difference (in months) between two dates; =DATEDIF(A2,B2,"m") However there is a problem. When using the above formula the difference between these two dates- 1/4/2006 - 31/3/2006 The formual returns 11 months. This isn't correct as they are actually 364 days apart, and the difference I need to see for my purposes is 12 months. Does anybody have a solution? Many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to find the working days difference between to dates? | Excel Discussion (Misc queries) | |||
| difference between dates | Excel Discussion (Misc queries) | |||
| I need the difference between two dates expressed as 4 years 3 mo. | Excel Discussion (Misc queries) | |||
| Difference betn 2 Dates | Excel Discussion (Misc queries) | |||
| How do I calculate the difference between 2 dates (m,d,y) ? | Excel Worksheet Functions | |||
Threaded Mode
