PieterBez
New Member
- Joined
- Mar 3, 2011
- Messages
- 1
Hi people im trying to work this out I want an automatic formula that will show days ahead and days behind using the percentage todays date and the baseline Finnish date.
Attach is an image of what I tried so far and failed the yellow block is the calculation im looking for say for example today is th 21st January and the task is only 10% completed and should have been completed by the 1st January the yellow block should display -20 and visa versa if a project is ahead as say should have finished the 21st Feb and today is the 16 January but the percentage is 70% it should say 12 as a positive.
Attach is an image of what I tried so far and failed the yellow block is the calculation im looking for say for example today is th 21st January and the task is only 10% completed and should have been completed by the 1st January the yellow block should display -20 and visa versa if a project is ahead as say should have finished the 21st Feb and today is the 16 January but the percentage is 70% it should say 12 as a positive.
