|
#1
|
|||
|
|||
Apply a formula based on whether a cell is blank or has a date
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 |
#2
|
|||
|
|||
An uploaded sample might help, but based on your description, try...
=IF(N(X2),NETWORKDAYS(N2,X2)-1,IF(X2="",TODAY()-N2,"")) |
#3
|
|||
|
|||
Maybe something like (on fly)
Code:
=NETWORKINGDAYS(N2, IF(X2="",TODAY(),X2))-1 |
#4
|
||||
|
||||
Is NETWORKINGDAYS a new function in Excel? Can't seem to find any information??
|
#5
|
|||
|
|||
Quote:
A good eye to catch this! I didn't think to check spelling! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
if cell contains date, then month, else blank | Merlot | Excel | 4 | 10-03-2016 03:27 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 |