Hello! Please help me a little with Date formulas in MS Excel 2000. I have a Cell (A1) with a 'dd.mm.yy' value, and i wanna make Excel to calculate How many days are left until that Day. Please Help with some Advice or Example! Save me... ;) Take Care and Peace to all! Dejan Vukovic, SLovenia

Hi Dejan, There are a few ways for doing this, i'll explain just one, that will do the trick quite well, imho. In cell B1 enter the following =now() copy the format from cell A1 to Cell B1 in Cell C1 enter the following =int(B1-A1) you can loose the decimals by changing the format, this has the advantage that the cell value of C1 changes when the clock passes midnight Hope this will help With regards Mike

Hello Just realized that the formula is better when using in Cell C1 =int(A1-B1) this to prevent negative values to occur Mike