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

Muslim Pro

Animal Crossing: Pocket Camp

Tacticool - 5v5 shooter

Resident Evil 3: Raccoon City Demo

Minecraft: Education Edition

Ukulele Tabs & Chords

Amigurumi

HEALTHLYNKED COVID-19 Tracker

COVID Symptom Tracker

Zoom

Houseparty