IF statement with DATEDIF

[smazza]

I'm trying to write a formula & it keeps saying that my formula is incorrect. I want to say if there is a value in cell A1, then calculate the months between A1 & B2, otherwise, leave blank. Here is what I have been writing that keeps coming back incorrect.

=IF(A1>0,(=DATEDIF(A1,A2,"m")),"")

I have changed the A1>1/1/1900 & that isn't the issue. It's the DATEDIF statement because when if use the fx button, that's the only part that come up "Illogical."
<!-- / message -->

 

[VoG]

Try

=IF(A1>0,DATEDIF(A1,A2,"m"),"")

 

[T. Valko]

I'm trying to write a formula & it keeps saying that my formula is incorrect. I want to say if there is a value in cell A1, then calculate the months between A1 & B2, otherwise, leave blank. Here is what I have been writing that keeps coming back incorrect.

=IF(A1>0,(=DATEDIF(A1,A2,"m")),"")

I have changed the A1>1/1/1900 & that isn't the issue. It's the DATEDIF statement because when if use the fx button, that's the only part that come up "Illogical."
<!-- / message -->

Try something like this...

=IF(COUNT(A1,A2)<2,"",DATEDIF(A1,A2,"m"))

 

[smazza]

Thank VoG, it worked!