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")),"")
A1 is in date format which might be the problem, but I don't know what else to put.
=IF(A1>0,(=DATEDIF(A1,A2,"m")),"")
A1 is in date format which might be the problem, but I don't know what else to put.