If sate ment using edate

M

Merge

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
 
R

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
Click to expand...

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

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

Merge

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

LongTermNoob

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