Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function & Nework Days
Adam,
You were close:- =IF(J10="Yes",WORKDAY(B10,5),"N/A") Mike "Adam" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function & Nework Days
Mike
That is excellent. Thank you very much. I'm new to excel so I find this group really useful. Regards, Adam "Mike H" wrote: Adam, You were close:- =IF(J10="Yes",WORKDAY(B10,5),"N/A") Mike "Adam" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function & Nework Days
Your welcome and thanks for the feedback.
"Adam" wrote: Mike That is excellent. Thank you very much. I'm new to excel so I find this group really useful. Regards, Adam "Mike H" wrote: Adam, You were close:- =IF(J10="Yes",WORKDAY(B10,5),"N/A") Mike "Adam" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want the PMT function to calculate using 360 days not 365 | Excel Worksheet Functions | |||
Days(360) function | Excel Discussion (Misc queries) | |||
work days function | Excel Worksheet Functions | |||
Function Help - Counting Days | Excel Discussion (Misc queries) | |||
Function to sort days | Excel Worksheet Functions |