I need the formula to enter a date on one worksheet and then have it updated
6 months inthe future and be automatically entered on another worksheet.

Hi,

The following formula will return the date 6 months into the future.
Suppose the starting date is in cell A1:
=EDATE(A1,6)

To use the Edate function choose Tools, Add-ins, and put a check beside
Analysis ToolPak.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

Cheers,
Shane Devenshire

"Ron" wrote:

I need the formula to enter a date on one worksheet and then have it updated
6 months inthe future and be automatically entered on another worksheet.

Assuming the date is entered into A1 on Sheet1, put this formula in the cell on the other sheet where you want the date that is 6 months in the future...

=DATE(YEAR(Sheet1!A1),MONTH(Sheet1!A1)+6,DAY(Sheet 1!A1))

Adjust the sheet name and cell reference as necessary and don't forget the leading and trailing apostrophes around the sheet name if it has any spaces in it.

--
Rick (MVP - Excel)


"Ron" wrote in message ...
I need the formula to enter a date on one worksheet and then have it updated
6 months inthe future and be automatically entered on another worksheet.