Forum

Notifications
Clear all

Workday Intl Formula to be excluded in Project dash board

5 Posts
2 Users
0 Reactions
70 Views
(@saktibasnet)
Posts: 3
Active Member
Topic starter
 

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.

 
Posted : 30/08/2020 6:32 am
(@mynda)
Posts: 4761
Member Admin
 

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

 
Posted : 30/08/2020 7:03 pm
(@saktibasnet)
Posts: 3
Active Member
Topic starter
 

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.

 
Posted : 31/08/2020 11:58 pm
(@mynda)
Posts: 4761
Member Admin
 

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

 
Posted : 01/09/2020 2:08 am
(@saktibasnet)
Posts: 3
Active Member
Topic starter
 

Thank u for the suggestion. however I tried again but still failed.

Please refer the file attached herewith.

 
Posted : 01/09/2020 12:22 pm
Share: