Formula using WORKDAY, TODAY, ISBLANK - #INCORRECT ARGUMENT

markh10

I want to calculate the number of days that a ticket is in Backlog.

[Ticket Status]@row = "Backlog"

WORKDAY([Date Submitted]@row, TODAY()) is the number of days from the date of submission to current date.

I realize that my Date Submitted cell sometimes is blank so I added:

NOT(ISBLANK([Date Submitted@row]) check. Now it is:

=IF(AND([Ticket Status]@row = "Backlog", NOT(ISBLANK([Date Submitted]@row)), WORKDAY([Date Submitted]@row, TODAY()), 0))

So IF the conditions of Ticket Status is Backlog AND the cell of Date Submitted is Not Blank THEN calculate the days from Date Submitted to Today else return 0.

I get #INCORRECT ARGUMENT

ericncarr

Hi @markh10 ,

I think the main issue is just that you need to use NETWORKDAYS instead of WORKDAY, so it would be like this:

=IF(AND([Ticket Status]@row = "Backlog", NOT(ISBLANK([Date Submitted]@row))), NETWORKDAYS([Date Submitted]@row, TODAY()), 0)

ericncarr

Hi @markh10 ,

I think the main issue is just that you need to use NETWORKDAYS instead of WORKDAY, so it would be like this:

=IF(AND([Ticket Status]@row = "Backlog", NOT(ISBLANK([Date Submitted]@row))), NETWORKDAYS([Date Submitted]@row, TODAY()), 0)