Solved Trying to combine an IF statement with NETWORKDAYS

July 18, 2014 at 06:05:50
Specs: Windows 7
this is the formula i have and it calculates the total days between F4 and T4 but i want to calculate the network days any ideas
=IF(T4=0,TODAY()-F4,T4-F4)

See More: Trying to combine an IF statement with NETWORKDAYS

Report •


#1
July 18, 2014 at 06:17:30
Try something like:

=IF(T4=0,NETWORKDAYS(TODAY(),F4),NETWORKDAYS(T4,F4))

see how that works.

MIKE

http://www.skeptic.com/


Report •

#2
July 18, 2014 at 08:21:06
✔ Best Answer
Just noticed that you may have to swap around the dates to get what your looking for:

The syntax is: NETWORKDAYS(Start_Date,End_Date)

Not knowing which is your Start_date and which is your End_date,
one or the other should work.

=IF(T4=0,NETWORKDAYS(F4,TODAY()),NETWORKDAYS(F4,T4))
or
=IF(T4=0,NETWORKDAYS(TODAY(),F4),NETWORKDAYS(T4,F4))

MIKE

http://www.skeptic.com/


Report •

#3
July 25, 2014 at 07:13:34
Thanks mike worked perfect

Report •

Related Solutions


Ask Question