Adding a day counter

[Dooha]

I'm using Excel 2003 and I would like to add a timer or a conditional format to count the number of days since a date was put in a cell.

e.g. If I put a date in A1, I would like B1 to state the number of days since it was put in. Is there a formula I can use in conditional formatting to achieve this?

 

[JamesW]

Hi,

You could use: =today()-A1 and format as a number.

 

[VoG]

You can just use a regular formula in B1

=TODAY()-A1

format as Number.

 

[Dooha]

How do you format as a number?

 

[VoG]

Click in B1, press CTRL + 1, click on Number, change decimal places to 0, click OK.

 

[Dooha]

Hmmm, I have 11/04/2011 in J5. K5 has a conditional format =TODAY()-J5. And cell k5 format is number to 0 decimal places. But I dont get anything displayed. Any ideas?

 

[VoG]

That is a formula not a conditional format and it works for me

Excel Workbook
	J	K
5	11/04/2011	17
Sheet2

 

[Dooha]

Ahhh, that makes sense. Worked for me too, thank you. Super star!

 

[Dooha]

At the moment I have J5 conditionally formatted to turn Red when I5 has the word 'Complete' in it. I would like J5 to turn Green when data is added to it. Is this possible?

 

[VoG]

You need to add another CF using Formula Is and the formula

=J5<>""