
Active Member

August 29, 2020

Good afternoon.
I was going through the tutorial Interactive excel project Management. I managed to summarise all the information in my excel file.
But in the end, while formatting for completed/ in progress / not complete data, in the video it has used workday.intl formula.
whereas in the project m working its 7 days woking period.
Please suggest.


July 16, 2010

Hi Sakti,
Welcome to our forum! The WORKDAY.INTL function is simply adding the days complete to the start date but skipping weekends. If you don't need to skip weekends you simply add the days complete to the start date without any function.
e.g. the formula for the actual days complete conditional formatting would be:
=AND(K$5>=$D6,$D6+$G6-1>=K$5)
I hope that points you in the right direction.
Mynda


July 16, 2010

Your file doesn't show me what you tried. I don't want to do it for you, I'd like to see what you tried, because then I can teach you where you went wrong. I suspect you haven't got the absolute and relative referencing correct. Please watch this tutorial on how to set up conditional formatting using relative and absolute references:
1 Guest(s)
