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

Grammarly Keyboard

Amazon Fire TV

OnLog

Tricount

Citymapper

YAZIO

Candy Crush for PC

CallApp

Garena Free Fire: Spooky Night

30 Day Fitness Challenge-Workout at Home

Pokémon Masters