So you want to put a date in I2, for instance and dates to appear
automatically in H2 and J2?
Try this formula in H2
=EDATE(I2,-3)
and this in J2
=H2-4
format all cells in date format
note EDATE is part of Analaysis ToolPak addin
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=505939