Date fomula not working
On Tue, 17 Feb 2009 02:15:01 -0800, FangYR
wrote:
In G2 this formula was
inserted:=DATE(YEAR(A2)-1,MONTH(A2),DAY(A2))-(MONTH(DATE(YEAR(A2)-1,MONTH(A2),DAY(A2)))<MONTH(A2)),
and i expext Excel to make changes in A2 to give this "3-Jan-2008" reading.
A formula in G2 cannot change the value in A2.
--ron
|