plus 6 month

[H Meisels]

Hi all
I want to make a formula to know waht is the exect day from 6 month's of
today's date


bill

 

[Frank Kabel]

Hi
=DATE(YEAR(A1),MONTH(A1)+6,MIN(DAY(A1),DAY(DATE(YEAR(A1),MONTH(A1)+6+1,
0))))

Also see:
http://www.cpearson.com/excel/datearith.htm

 

[Bill Kuunders]

Souds like you are looking for a best before date or expiry date.

Use the edate function.

=edate(a1,6)
a1.......... = today()
regards
Bill K