Hi all I want to make a formula to know waht is the exect day from 6 month's of today's date bill
H H Meisels Nov 15, 2004 #1 Hi all I want to make a formula to know waht is the exect day from 6 month's of today's date bill
F Frank Kabel Nov 15, 2004 #2 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
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
B Bill Kuunders Nov 16, 2004 #3 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
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
