Thread: [Solved] Help with DATEDIF Formula
View Single Post
 
Old 01-12-2012, 06:58 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows XP Office 2003
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

I don't get it, as Datedif counts complete months between two dates,

=Datedif(01/01/2012,29/03/2012,"m") equates to 2 for me, not 3
So =datedif(01/02/2012,29/03/2012,"m") would yield 1
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote