I have a risk register. When there is High in collum 1 and High in Collum 2 I want it to return High and Red, same for high and med, med and low, med and med ect....
Is there a easier way than complting a long If formula?
Hi I'm having problems calaculating the network days between the end of the year and next year.
This is what I have
27/12/2011 16/01/2012 =networkdays(27/12/2011,16/01/2012) and an error checking box appears with the number "0"
Please help..
Thank you.
I will be using the formula from NARAYANK991
But it was a simple Hlookup that I trying and it returned the week that the date fell into that the item was due.
Thanks all for you comments
I have purchased the excel project templates and I have to say they are great.
I'm having a problem though.....
In the Gantt Chart Template
I want to automate the highlighting of the current week.
Also if I insert a column say 'Due Date' I would like the Start week to populate...