View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Adam Adam is offline
external usenet poster
 
Posts: 287
Default IF Function & Nework Days

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.