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
If function with dates in excel ✓ - 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

TikTok

Garena Free Fire: 3volution

Animal Crossing: Pocket Camp

Minecraft Dungeons

Instagram for Android

Airbnb

Meet

COVID Symptom Tracker

Zoom

Spotify for Android