EDATE function problem calculating blank cell

[SpiritedAway]

I'm using the EDATE function to calculate due dates. Col A is 'Start Month' & Col B is 'month frequency'

In Col C I use:

Please Login or Register  to view this content.

Which returns the due date in C2.

But having an issue: when there's a date in Col A but Col B is empty - Col C is returning the value of Col A instead of being blank.

I tried:

Please Login or Register  to view this content.

But isn't working. Can anyone advise the best solution to this problem.

[daddylonglegs]

" " is a space, for a blank use "" like this

=IF(B2="","",EDATE(A2,B2)

[Tony Valko]

Maybe this...

=IF(COUNT(A2:B2)<2,"",EDATE(A2,B2))

Format as Date