Networkdays when second date is empty

Angie Hatfield · 04/22/19

I'm trying to figure out how to get the network days when the second date column is blank. It should then just be 1.

I'm going crazy trying to figure it out.

Update: I am still playing with this formula. I've realized I just need an IFBlank formula. If blank, return 1.

My formula returns #Incorrect argument set

=IF(ISBLANK([PTO Date]4, "1"))

=IF(ISBLANK([PTO Date]4, 1))

=ISBLANK([PTO Date]4, "1")

=ISBLANK([PTO Date]4, 1)

Angie Hatfield · 04/22/19

Realized that I do need Networkdays and if no second date field is blank, return 1.

Thanks for looking!

Angie Hatfield · 04/22/19

SOLVED!

=IF(AND(ISDATE([PTO Start Date]2), ISDATE([PTO end date]2)), NETWORKDAYS([PTO Start Date]2, [PTO end date]2))

I was wrong, I don't want it to return 1, I need no amount to show.

Comments