DATEDIF function query

[Julio Medallion]

I am using the DATEDIF function to calculate the number of days or months
between dates, e.g. DATEDIF(A1,B1,"m"), using d for days and m for months in the formula. My query is- is it possible to work out the number of weeks using this formula? Using "w" in the formula returns a #NUM! error.

 

[GlennUK]

Isn't number of weeks the same as getting the number of days and dividing by 7?

 

[CharlesChuckieCharles]

divide by 7?

 

[Julio Medallion]

Yes, I had actually thought of that, I was just wondering if there was an equivalent to the day or month i.e. d or m in writing the formula?

Which leads to my next question when using the month formula, two of my formulas are calculating the number of months, both cells have 30 days in them but one formula calculates it as 1 and another calculates it as 0. Does the formula intervals have to have the same start dates, i.e. with (1/1,1/2) the formulacalculates 1 month,but the formula that calcuates 0 months starts (2/10/11,1/11/11).

 

[CharlesChuckieCharles]

DateDif doesn't want to Lie to you

What are you actually trying to do?