Hi Guys,
I'll try and keep this simple.
I need a formula resembling - show weeks (or months) between Date A and Date B, only if cell X contains "Won".
More descriptively, the result I need to know is how many weeks or months it has taken to win a quotation, using the date issues and the date won, but the formula should only function when a shows won.
Example:
Cell C1 = date issued
Cell AU = status, which will contain "Won"
Cell AW = date won
I'll try and keep this simple.
I need a formula resembling - show weeks (or months) between Date A and Date B, only if cell X contains "Won".
More descriptively, the result I need to know is how many weeks or months it has taken to win a quotation, using the date issues and the date won, but the formula should only function when a shows won.
Example:
Cell C1 = date issued
Cell AU = status, which will contain "Won"
Cell AW = date won