Formula to count days between a date and TODAY, ignore blanks

Christina Reid

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())

Paul Newcome

You could try an IFERROR to make it blank like so...

=IFERROR(NETWORKDAY([NIGO Date]2, TODAY()), "")

Paul Newcome

You could try an IFERROR to make it blank like so...

=IFERROR(NETWORKDAY([NIGO Date]2, TODAY()), "")

Christina Reid

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()))

Paul Newcome

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).

Wina Hathaway

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

Paul Newcome

@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?

Wina Hathaway

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

Paul Newcome

@Wina Hathaway You could use a basic IFERROR statement for this...

=IFERROR(NETWORKDAYS(..................), "")