Best formula to track days

[broncos347]

I have a tracking spreadsheet and what I am trying to do is to track those specific actions that have the label "issued" in column K. Then if they do, I'd like to be able to track the number of days the action has be open (0-10, 11-20, etc) which would be shown in columns, D, E, etc.

Can anyone advise on what would be the best formula?

 

[rcbunting]

Well... I dunno about "Best," but the slimpliest is just to subtract the dates and format the result as a number.

=IF(K1="Issued", E1-D1)

If you're looking to just count 'Work Days' (i.e. the number of weekdays) then use networked days.

=IF(K2="Issued", NETWORKDAYS(D2,E2))

GL