Count days

[sdc1234]

Count formula: if I depart on 1 Jan 11(cell c1) and it in 4 Jan 11 then I want my days field ( cell c3) to = 3, also if I hit day 27 I want the box to change to red

 

[Willmonbo]

Sorry there seems to be a few typos in your post, can you re-post with corrections, also what box do you want to turn red?

 

[sdc1234]

Count formula: if I depart on 1 Jan 11(cell c1) and it is 4 Jan 11 then I want my days field ( cell c3) to = 3, also if I hit day 27 I want the cell to change to red( cell c3)
Sorry bout the errors...

 

[T. Valko]

Count formula: if I depart on 1 Jan 11(cell c1) and it is 4 Jan 11 then I want my days field ( cell c3) to = 3, also if I hit day 27 I want the cell to change to red( cell c3)
Sorry bout the errors...

What version of Excel are you using?

 

[Haseeb Avarakkan]

Hi,

I think you can simply use in C3;

=C2-C1

Then change the cell format >> Custom; to

[Red][>=27]0

 

[sdc1234]

thanks it worked, now how do I set it to cont the days that I have been gone for days cell c4, date of departure is c3 I do not have a departure date
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden"><input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[sdc1234]

What version of Excel are you using?

2007
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[Dryver14]

put departure date in C1

=Today() in C2

and then use Haseeb's formulas in C3

 

[sdc1234]

thanks it worked