How many days between dates

[cjbrown815]

Hello,
Excel 2010

I have a column that has a date mm/dd/yyyy
I need to insert a column (Timeline Status) that shows how many days from today to that date. If today is after that date I want a negative balance in red.

Date due 10/01/2011
Today is 10/06/2011
Timeline Status -5 days (in red)

thanks

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[SkipVought]

hi,

It is the mathematical difference, that simple!

Use Conditional Foramtting to shade your values as required.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[cjbrown815]

Its the TODAY()-CELL ?

Please help with formula, thanks

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[SkipVought]

did you try it?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[cjbrown815]

Yes, I tried

=H2-TODAY()


H2 being the cell that has the date and it isnt working

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[SkipVought]

hmmmmm?
[tt]
TODAY()-CELL
[/tt]
sure does not look like
[tt]
H2-TODAY()
[/tt]
Can you see the difference???

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[cjbrown815]

This one worked now...Thanks Skip

=H2-TODAY()

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[SkipVought]

So what was the problem on post 6 Oct 11 15:34?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[kendue]

Format your formula cell as a number and your answer will be accurate using the =H2-Today() formula.

Then Conditionally format that same cell as color red for value less than zero.

 

[BlueHorizon]

Hi,

You can also go into the Format Cells dialog box and select the red choice for negative numbers in the lower right.

HTH,


Best,
Blue Horizon