Date Outstanding - Requested, Responded and Today

[grahfchart]

Hello,

Is there a way to setup an excel formula to provide a day outstanding number?

I need it to do the following:

Subtract Date requested from todays date unless date responded is filled in.

Thanks in advance,

Grahfchart

 

[jtakw]

Hi,

Something like this?

Excel 2010
	A	B	C
1	Date requested	date responded	days outstanding
2	2/1/2016	3/5/2016
3	2/10/2016		114
4	3/1/2016	4/30/2016
Sheet1

Cell Formulas
Range	Formula
C2	=IF(B2="",TODAY()-A2,"")

C2 formula copied down.

 

[grahfchart]

Yes, however there are a few more things that I would like to accomplish.

If there is a value for A2 and B2 or just A2, can there a be an automatic drop down list that reads Open or Closed (Open if Date Responded is not filled, Closed if not filled).

In addition to that, if there is a value for A2 and B2 present, can it still calculate Days Outstanding?

Thanks again,
Grahfchart