grassyknoll63
New Member
- Joined
- Dec 18, 2016
- Messages
- 7
Hi,
I'm creating a tracking sheet and, have dates work is requested in I1 and dates work is completed in J1. And, in K1 I have the number of days it took. Until the work is completed, I'd like to have the days since work was requested in K1. Also, if both I1 and J1 are blank (no work requested, yet), I'd like the cell to be either blank or 0. Is this something someone may know how to solve?
Thanks!
gn
I'm creating a tracking sheet and, have dates work is requested in I1 and dates work is completed in J1. And, in K1 I have the number of days it took. Until the work is completed, I'd like to have the days since work was requested in K1. Also, if both I1 and J1 are blank (no work requested, yet), I'd like the cell to be either blank or 0. Is this something someone may know how to solve?
Thanks!
gn