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

"Merge" wrote:

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

"Merge" wrote:

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