Prev: Excel 2007
Next: Chart Data Point Size Changing ?
From: David on 18 Dec 2009 14:00
How to set a formula to count the number of month between two dates?
example:
Jan 5,2009 to Feb 4, 2009 = 1 month
Feb 5, 2009 to Apr 6, 2009 = 3 month (round up)

From: "David Biddulph" groups [at] on 18 Dec 2009 14:42
=DATEDIF(A2,B2+1,"m")+(DATEDIF(A2,B2+1,"md")>0)
--
David Biddulph

"David" <David(a)discussions.microsoft.com> wrote in message
news:92596742-44EA-4A26-B5B9-63EA24756497(a)microsoft.com...
> How to set a formula to count the number of month between two dates?
> example:
> Jan 5,2009 to Feb 4, 2009 = 1 month
> Feb 5, 2009 to Apr 6, 2009 = 3 month (round up)
>


 | 
Pages: 1
Prev: Excel 2007
Next: Chart Data Point Size Changing ?