in N1 3/15/02 or 15/03/02 depending on how your system is set up (edited)
in M1 =DATE(YEAR(N1),MONTH(N1)-1,DAY(N1))
copy M1 to L to A
Set references to absolute if all months
are to be - 1.
Format the cells so the information fits.
[ This Message was edited by: Dave Patton on 2002-03-28 19:59 ]
[ This Message was edited by: Dave Patton on 2002-03-28 20:01 ]
Like this thread? Share it with others