This is just for fun (demented, I know)
The poor man's edate (will be wrong 3 days every four years).
=DATE(YEAR(A1),MONTH(A1)+1,MIN(DAY(A1),VLOOKUP(MONTH(A1)+1,{13,31;2,28;3,31;4,30;5,31;6,30;7,31;8,31;9,30;10,31;11,30;12,31},2,0)))
Okay, here is the fix until, I believe the year 4000
=DATE(YEAR(B2),MONTH(B2)+1,MIN(DAY(B2),VLOOKUP(MONTH(B2)+1,{13,31;2,28;3,31;4,30;5,31;6,30;7,31;8,31;9,30;10,31;11,30;12,31},2,0))+((MONTH(B2)=1)*(MOD(YEAR(B2),4)=0)*(DAY(B2)>28)))
This message was edited by iml on 2002-04-10 12:20