Sunday, August 14, 2011
I need a formula for Excel?
I have a date column. I need the next column to display a number either in Green with a "+" sign in front OR in Red with a "-" sign in front. I need it to always calculate between the date I have in say Column X and the current date. The number to use for the calculation is 90. So if my Column X date is 1 OCT and today is 5 OCT then my calculated number should be a green "+86" since it is only 4 days later. If my Column X date is 1 JUL then I should have a red "-6" since it is 96 days past the annotated date in column X. Can't count the date in Column X into the equation, need to start with the day after. If the date in Column X is the same as the current date then simply in a black "0". Also, can the date be displayed as 5 Oct 08 or do I need to change it too all numbers. Basically I have devised a "Lateness" chart for reports due 90 days later and I need to track how many days are left in the green or how many days late/in the red.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment