Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Number of days left shown???
Hi there...
I would like to ask if there;s any formula for this?? I have a spreadsheet with names and due date.......there;s a conditional format for it....which within 14 days of the due date....it would turn "orange" and when the due date reach....it would turn "red" colour...... but now i need to add in....Let's say.....when the "orange" colour appears (meaning within 14 days of the due date) ....it would appear on the orange colour cell itself or another new column next to it showing .....how many days left from the 14 days? E.g. 14 for today, 13 for tomorrow, 12, 11, 10 ...and goes on till it turns "red" (due date) ........and it would count again from this due date....1 , 2, 3 days and etc .......meaning showing how many days has it due already??....... Pls Do help me on what formulas can i use? Cheers to all....Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Determining number of days between dates | Excel Worksheet Functions | |||
Calculating interest on number of days in the period | Excel Worksheet Functions | |||
Calculating for number of days when values are in dates | Excel Worksheet Functions | |||
Random Number Questions | Excel Worksheet Functions |