A2 is PAYMENT DUE DATE
B2 is PAYMENT RECEIVED DATE
C2 is MONTHS PASS DUE
i need a formula to insert in cell C2 that will calculate the number of months the payment is passdue, but if B2 is blank, then I want it to calculate the number of months pass due using the current date.
i used the DATEIF(A2,B2,"M") to calculate the months pass due but I need help adding the condition that if B2 is blank, to then calculate the number of months using the current date. I know that if I enter =TODAY () in a cell it will display the current date in that cell. I Just don't know how to link the formulas to make it do what I need. Please help!