Excel formula - show # of days remaining

[TopDawg]

Looking for a formula which will show number of days remaining till a certain date. Loking for the cell to auto update when you open the sheet.

example -

lease expires on 11/30/06 Number of days left 5

Thanks in advance

 

[AnotherHiggins]

Put 11/30/06 in A1.

In B1, type in [COLOR=blue white]=A1-Today()[/color]. format the cell containing the formula as General (Format > Cells > Number > General).

ps There are 35 days between now and November 30th.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[TopDawg]

Thank YOU !!..

Works great, I was trying to make it soo much more harder than your formula.

Is there a way to make the number go red if it is within a certin number of days? example- number of days remaining is less than 30, so 30 would be red..

Thanks.

 

[honorbum]

Use Conditional Formatting to change the color with set parameters. It's under Format on the menu bar.

 

[TopDawg]

Thanks, works great exactly what I needed.