date formula

[rjmdc]

i made an error and messed up my book
the formulas i need are:
if date [@[date] is not blank then date + 6 months else ""
i keep getting 1/1/1900 or something like that

please help me

 

[hagia_sofia]

Hello, something like this?

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

 

[rjmdc]

it worked beautifully
thanks
=IF([@[ LATEST DATE]]="","",EDATE([@[ LATEST DATE]],6))