If sate ment using edate

[Guest]

to keep my cell clear until someone enters data in another cell

I would like to do the following formula
=IF($G15="", "",edate($G15.1))

This is not working

G15 is a date

I want to say if g15 has a blank field ,leave empty, if it is not empty take
the date and add a month

It is probably simple, please help

 

[Ron Rosenfeld]

to keep my cell clear until someone enters data in another cell

I would like to do the following formula
=IF($G15="", "",edate($G15.1))

This is not working

G15 is a date

I want to say if g15 has a blank field ,leave empty, if it is not empty take
the date and add a month

It is probably simple, please help

=IF($G15="", "",edate($G15,1))
^

You need a comma, not a dot.
--ron

 

[Guest]

gee I feel stupid now
I fixed the period to a comma, but I tried it and getting the #name? error

 

[Guest]

Just in case: go to TOOLS > ADD-INS and make sure "Analysis ToolPak" is
checked.

 

[Guest]

Thank you to both

Just in case: go to TOOLS > ADD-INS and make sure "Analysis ToolPak" is
checked.