Using the IF function for dates

Solved/Closed

courtney - Dec 15, 2015 at 10:48 AM
RayH - Dec 15, 2015 at 12:49 PM

Hello,

I am trying to figure out in Microsoft excel 2010 the appropriate IF formula to use. I am trying to calculate the number of working days that I have from Column A to Column B However if Column B is empty I would like the formula to use the date in Column C. If both Columns are empty then I would like for the formula to leave the cell Blank.

Any tips on how to do this would be greatly appreciated.

Using the IF function for dates
Find function on mac - Guide
Accessor function c++ - Guide
Spreadsheet function - Guide
Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
Different dates of "end to end encryption message" on blank chat? ✓ - Network Forum

1 response

Answer 1 / 1

RayH
Dec 15, 2015 at 12:49 PM

This uses the Excel function NETWORKDAYS to return the number of working days.

=IF(NOT(ISBLANK(B1)),NETWORKDAYS(A1,B1),IF(NOT(ISBLANK(C1)),NETWORKDAYS(A1,C1),""))

Similar discussions

encryption message several time in chat

IF statements with dates and criteria

blank white page for website

help me to add particular cells

"Sorry, this feature isn't available ... " how to fix this?

Similar discussions

Subscribe To Our Newsletter!