Date Calculation with Blanks

[hjm]

Hi,

I am using the formula =EDATE(B3,6) to automatically add 6 months to the
date in cell B3, but I need to know if I can extend this to show a blank cel
or N/A if B3 does not yet have a date in it.

Help!!!

 

[Pete_UK]

Try this:

=IF(B3="","",EDATE(B3,6))

Hope this helps.

Pete

 

[hjm]

Thats excellent, thank you!

Try this:

=IF(B3="","",EDATE(B3,6))

Hope this helps.

Pete

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

Thats excellent, thank you!





- Show quoted text -