How do I say in C1 that I want =A1-B1 only where A1 and B1 both contain a date?
I am tracking how long it takes for a task to get done w the simple formula of =A1-B1 in my C1 cell. A1 and B1 contain dates or are blank until the task on that line is done. I use the C column to create an average.
I just discovered if A1 and B1 are both empty, I am getting a 0 in C1 which is throwing off my average calculation. I cannot just exclude 0 from the formula that averages the C column bc the result in C is often 0 since A1 and B1 are supposed to happen on the same date.
I know it is something simple, but I hit a brain block. Help!
Bookmarks