M
Matt
I have received some great help on here and again I am seeking more guidance
(sorry).
I have been tasked with setting up some spreadsheets at work to on
applications coming into my department and the number of days it takes for us
to deal with them. I am also looking at number of written enquiries as well.
Using the following headings Application Received (B4), Enquiry Received
(C4), Completed Date (E4).
Then using the following formula
=NETWORKDAYS(IF(B4<>"",B4,C4),E4,$A$119:$A$158)
So that it will look at B4 determine if a date is in the cell if it isn’t
populated it looks at C4 instead whichever cell is completed it then works
out the networkdays by looking at E4. The text within the $ signs refer to
bank holidays listed on the spreadsheet
Would it be possible to have anything in place that does that formula but
depending on which cell was used (B4 or C4) it would provide the answer in a
different coloured font? For example it works out which date it has to use
for doing the networkdays and if it’s used the date in B4 when providing the
answer (number of days)it remains normal font colour (black) and if it uses
the date in C4 the answer turns red font.
If so would someone be so kind in advising the formula I would need to use.
Thanking you in advance
(sorry).
I have been tasked with setting up some spreadsheets at work to on
applications coming into my department and the number of days it takes for us
to deal with them. I am also looking at number of written enquiries as well.
Using the following headings Application Received (B4), Enquiry Received
(C4), Completed Date (E4).
Then using the following formula
=NETWORKDAYS(IF(B4<>"",B4,C4),E4,$A$119:$A$158)
So that it will look at B4 determine if a date is in the cell if it isn’t
populated it looks at C4 instead whichever cell is completed it then works
out the networkdays by looking at E4. The text within the $ signs refer to
bank holidays listed on the spreadsheet
Would it be possible to have anything in place that does that formula but
depending on which cell was used (B4 or C4) it would provide the answer in a
different coloured font? For example it works out which date it has to use
for doing the networkdays and if it’s used the date in B4 when providing the
answer (number of days)it remains normal font colour (black) and if it uses
the date in C4 the answer turns red font.
If so would someone be so kind in advising the formula I would need to use.
Thanking you in advance