Forum Discussion
Need your help with Timeline
Hello guys how are you doing I hope you are doing well, I need your guy's help adding a timeline column in excel, the problem that I have is that the calculation is not straight forward I will sh...
The formula I used calculates the duration
duration
= IF(close>open, close - open, today - open)This is then used as the positive error bar of a scatter chart in which the project number is plotted against the opening date.