IF Function & Nework Days

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adam - 13 Jul 2007 10:58 GMT

Hi

I've been working on the formula below but I can't get it to work:

=IF(J10="Yes","(NETWORKDAYS(B10)+5)","N/A")

Cell J10 is in my "Response Required?" column.
Cell B10 is in my "Date Received" column.
The above formula will go in my Target Date column.

If there's no response required then I'd like the cell to say "N/A." If
there is a response required I want the cell to show a date that is 5 working
days from the date received.

Your help would be much appreciated.

Reply to this Message

Mike H - 13 Jul 2007 11:10 GMT

Adam,

You were close:-

=IF(J10="Yes",WORKDAY(B10,5),"N/A")

Mike

> Hi
>
[quoted text clipped - 11 lines]
>
> Your help would be much appreciated.

Reply to this Message

Adam - 13 Jul 2007 11:12 GMT

Mike

That is excellent. Thank you very much. I'm new to excel so I find this
group really useful.

Regards,
Adam

> Adam,
>
[quoted text clipped - 19 lines]
> >
> > Your help would be much appreciated.

Reply to this Message

Mike H - 13 Jul 2007 12:12 GMT

Your welcome and thanks for the feedback.

> Mike
>
[quoted text clipped - 27 lines]
> > >
> > > Your help would be much appreciated.

Reply to this Message