Excel Formula Help

[oHUTCHYo]

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

 

[DaleTheWhale]

For showing difference in work days:

=IF(AU="Won", (NETWORKDAYS(C1,AW) & " Days"), "STATUS NOT WON")

For showing difference including weekends/bank holidays:

=IF(AU="Won", ((AW-C1) & " Days"), "STATUS NOT WON")