I'm having problems getting the number of days if other cell has "Closed" in it.
Start Date = G2
End Date = H2
Closed = F2
What I need to do is only calculate the number of days if cell F2 has the word Closed in it. When cell F2 does not say closed it will say Open but I don't need the formula to look at that.
Thank You
Bookmarks