Using the IF function for dates [Solved/Closed]

Report
-
 RayH -
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.



1 reply

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),""))
3
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!