Formula to count days between a date and TODAY, ignore blanks
Hi -
I have a column titled NIGO Date, which may or may not have a date. I then want a formula in the next column Age of NIGO that will count the days between that date and today. I also need it to ignore blanks.
I have tried a ton of different formulas and keep getting #Unparseable errors.
This is what I"m starting with, which works, until the cell is blank.
=NETWORKDAY([NIGO Date]2, TODAY())
Best Answer
-
You could try an IFERROR to make it blank like so...
=IFERROR(NETWORKDAY([NIGO Date]2, TODAY()), "")
Answers
-
You could try an IFERROR to make it blank like so...
=IFERROR(NETWORKDAY([NIGO Date]2, TODAY()), "")
-
I of course couldn't let this go so kept working on it and just got this to work for me probably about three minutes before your response came in! I should be more patient, but thank you for your help!
=IF(OR([NIGO Date]1 = ""), "", NETWORKDAY([NIGO Date]1, TODAY()))
-
Happy to help! 👍️
A final note... You actually don't need the OR function in your above solution.
=IF([NIGO Date]1 = "", "", NETWORKDAY([NIGO Date]1, TODAY()))
It will work the same and is one less set of parenthesis (which are a royal pain when you start getting into more complex formulas).
-
I have the same issue but I could not figure out the formula. I need to count how many work days have passed since a date and if blank leave cell empty.
Date to Vendor / Today /
and also
Date to vendor / date submitted
-
@Wina Hathaway I'm not sure I follow. Leave blank if which date is blank? And are you looking for two separate formulas or are you wanting to swap today out with [date submitted] if [date submitted] is blank?
-
sorry! now I'm reading my post it doesn't make sense!
I meant to not have an error message if the date submitted cell is empty.
thank you!
W
-
@Wina Hathaway You could use a basic IFERROR statement for this...
=IFERROR(NETWORKDAYS(..................), "")
Help Article Resources
Categories
Check out the Formula Handbook template!
