I'd need some help to do create a formula in a cell to do the following:
If date resolved cell (column K - e.g. K2) has no value, take today's date minus (Date reported - column B e.g. B2). If date resolved (K2) is has a value, then (K2 - Today's date)
In other words, I'm trying do do here is calculate the aging of a software defect/bug If the defect hasn't been resolved yet (there will be no value in column K - date resolvedl), then the cell value (based on formula I want to create) will change on a daily basis - whatever todays date is minus the date it was reported. Once it's resolved, it just will be the date the bug was reported minus the date it was resolved.
The calculation should not no include Sat/Sun as part of the calculation. Please let me know if you have any questions or need clarification. Thanks!