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.
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
Thank you mam for the response. I tried to use the formula, but ended highlighting whole sheet.
Could you please look at my attached file and suggest further what necessary changes need to be made in the sheet.
Its just for completed task/ in progress and not started.
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: https://youtu.be/Rzz9PyfwiVQ
Thank u for the suggestion. however I tried again but still failed.
Please refer the file attached herewith.