Formula to forecast end dates of individual activities

[Moggzy]

All,

the attached schedule has the following formula within it (in cell K8) that i can get to work as i require

=IF(O8>U1,K8=O8+I8,IF(O8<U1,K8=U1+I8))

I want the the formula to automatically populate with a forcast end date as data is input.


EG.

the report date in U1 is amended to the required date. As actual percentage complete is manulally input, the schedule automatically calculates a forecast end date based on:

remaining duration plus either the original planned end date or the date of the report, depending on which is greater in value.


thanks,

Moggzy

[BlastRanger]

I don't know if this help or not.
Try put in K5 :
=IF(M5>$U$1,M5+I5,IF(M5<$U$1,$U$1+I5,"ERROR"))
then copy down