Date Calculation with Blanks
 

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!!!

Date Calculation with Blanks
 

Try this:

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

Hope this helps.

Pete

On May 14, 10:26 am, hjm wrote:
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!!!

Date Calculation with Blanks
 

Thats excellent, thank you!

"Pete_UK" wrote:

Try this:

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

Hope this helps.

Pete

On May 14, 10:26 am, hjm wrote:
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!!!

Date Calculation with Blanks
 

You're welcome - thanks for feeding back.

Pete

On May 14, 11:14 am, hjm wrote:
Thats excellent, thank you!



"Pete_UK" wrote:
Try this:

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

Hope this helps.

Pete

On May 14, 10:26 am, hjm wrote:
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!!!- Hide quoted text -

- Show quoted text -