Excel Formula Question

[Dswissmiss]

Hi guys,
I'm not sure if this is the right place to post this type of question, so let me know if there is a better place to get an answer.

I'm trying to create a formula in excel.
Basically, I want to enter a "start date" into cell A1, "end date" into cell A2, and I was wondering what formula to use to give me a "days left" in cell A3. I would obviously want cell A3 to change everyday and give me the days left.

Bonus: If possible, I'd like the text in the "days left" cell to change color when, for example, only 5 days are left. If that's not possible, then if I could at least sort by "days left".

I appreciate any help. Again, let me know if there's a better website to get this kind of information from

Thank you
Dswissmiss

[Statica]

If A1 = TODAY() and B1 = 28/05/2007
A simple subtraction should work fine. The resultant cell must be formatted to show it as a number and not a date.

Excel help is a good place to check for the answer.. it also explains a function called NETWORKDAYS.

HTH

[pillainp]

One of the basic things to understand about Excel is that it indexes dates. That is to say, each day has a number attached to it. January 1, 1900, is therefore day 1, and every day thereafter, excel increments by one.

Therefore, the index number for 01 May 2007 is 39203

Statica's method is the easiest, and the above is the principle on which it works.

To have a cell or its text change color or formatting based on a value in that cell, use Conditional Formatting (Format>Conditional Formatting) and define your criteria there.