Using the IF function for dates [Solved/Closed]

Question

Using the IF function for dates [Solved/Closed]

Report

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
How do you do an if function with dates? - How-To - Excel
IF functions with dates ✓ - Forum - Excel
Some help needed about IF function with dates ✓ - Forum - Excel
Using IF function with dates ✓ - Forum - Excel
IF function using dates ✓ - Forum - Excel

1 reply

Ask a question

RayH · Accepted Answer · 2015-12-15T12:49:24-0500

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),""))

Using the IF function for dates [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!