Microsoft Office Forums - View Single Post - [Solved] Adding Formula

Thread: [Solved] Adding Formula

View Single Post

Old

12-17-2015, 04:27 AM

SumitBansal SumitBansal is offline

SumitBansal is offline

SumitBansal uses Windows 10

Windows 10 SumitBansal uses Office 2013

SumitBansal uses Office 2013

Office 2013

Novice

Join Date: Dec 2015

Location: India

Posts: 6

SumitBansal is on a distinguished road

Default

Try this:

=IF(ISBLANK(E6),TODAY()-B6,NETWORKDAYS(B6,E6,$F$6:$F$18))

Reply With Quote