Apply a formula based on whether a cell is blank or has a date

NLJ · #1 09-16-2021, 02:08 PM

I'm trying to create a formula that will allow me to use the =NETWORKINGDAYS(start, end)-1 formula if a cell contains a data or the =TODAY()-cell if the cell is blank, but I can not figure it out. I'm trying the IF statement, but I know I've got errors. Here is what I've tried =IF(X2=" ",[NETWORKINGDAYS(N2,X2)-1],IF[X2=<>" ",[TODAY()-N2]).

Each formula works separately, but I can't figure out how to combine these to use the formula applicable to being either blank or not blank
.

Any advice, it's been quite a while since I've done something like this.
Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
if cell contains date, then month, else blank	Merlot	Excel	7	03-20-2025 08:16 AM
Formula for looking at 1 cell with a date and then comparing it to four date ranges	LearningMom	Excel	3	10-27-2017 12:44 PM
Need help with using traffic lights in one cell based on date value in a different cell	wmedjaxnjr	Excel	1	04-09-2016 04:22 PM
calculate date if date entered in cell, do nothing if blank	ConfuddledOne	Excel	3	11-07-2014 09:37 AM
Change formula cell range based on cell value	Scoth	Excel	4	10-25-2012 07:51 AM