Thread: [Solved] Help with DATEDIF Formula
View Single Post
 
Old 01-12-2012, 08:17 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hi Caz,

I've attached an example which implements the formulae I posted above. For 1 Jan 12 vs. 29 Mar 12 it gives the result of 2 which I believe is what you want.

Note the formula in D2 is just a helper, so that the formulae in D4 to D9 are simpler.


If it's not returning the correct results then please elaborate.
Attached Files
File Type: xls Book1.xls (14.5 KB, 9 views)
Reply With Quote