Adding Formula

		Microsoft Office Forums > Microsoft Excel > Excel
Adding Formula

FAQ

Thread Tools

Display Modes

12-11-2015, 12:53 AM

Pecoflyer

Windows 7 64bit Adding Formula

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Your formula =IF(ISBLANK(E6);TODAY()-B6;(E6-B6)) becomes

Code:

=IF(ISBLANK(E6);NETWORKDAYS(B6,TODAY()),NETWORKDAYS(B6,E6))

You have the option to add a range to the function, range containing the holidays.

Check the function's syntax to see how it works

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help with dragging a formula and changing a reference column as I drag the formula.	LupeB	Excel	1	10-22-2015 03:02 PM
Adding Months	TimmiAndrew	Excel	2	09-16-2015 10:21 AM
adding a red box	jolinchew	Word	8	07-12-2013 11:46 PM
Adding Image into a excel cell and adding a hyperlink to the image	saravananiyyanar	Excel	3	05-04-2011 08:31 AM
Adding PDF	sussertown	Office	2	06-13-2009 01:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:52 AM.