Date entered in a cell affects the date produced in other cells

Hi

Not sure if this can be achieved with formulas or with programming but what a want to achieve is inputting a date into a cell and depending on what that date is, I need other dates appearing in adjoining cells. Any ideas?

Thanks

If you enter a date in cell A1, for instance, you can have this formula in B1:

=IF(A1="","",A1+91)

which will add 91 days onto the first date, as an example. Or, the formula in B1 could be:

=IF(A1="","",DATE(YEAR(A1),MONTH(A1)+6,DAY(A1)))

to add 6 month onto the first date.

I haven't a clue what you want to happen with those subsequent dates, so you will have to give us some more details of what you are trying to achieve.

Hope this helps.

Pete