I NEED TO ADD 90 DAYS TO A DATE IN A CELL IN EXCEL
M Matt Lunn Jul 19, 2005 #2 Hi Assuming the date value is in Cell A1 you could use =DATE(YEAR(A1),MONTH(A1), DAY(A1)+90) A shorter version is = A1 +90 Thanks, Matt HTH, Matt
Hi Assuming the date value is in Cell A1 you could use =DATE(YEAR(A1),MONTH(A1), DAY(A1)+90) A shorter version is = A1 +90 Thanks, Matt HTH, Matt