Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining dates based on colored cells.
I'm using Excel 2000.
What I'm trying to do is as follows: Lets say I have a row of numbers that are fiscal weeks like this, 1 2 3 4 5 6 7 8 9 10 and i have a row of empty boxes underneath them, which when changed to the color green, i want seperate cells to give the start and end dates of those fiscal weeks. How would I link the fiscal numbers to dates? and what kind of if-then statement would I need for it to calculate a time span? for example: green boxes under fiscal weeks 5 to 7 1 2 3 4 5 6 7 8 9 10 [g][g][g] then have two seperate cells, containing the calculated Start date, and the other with end date. i'd imagine linking the fiscal numbers to real dates would allow excel to add and subtract them. if it's too complex to be answered i understand, thanks ej |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determining consecutive dates? | Excel Worksheet Functions | |||
Determining Date X based on Other dates | Excel Worksheet Functions | |||
Calculating cells based on dates | Excel Worksheet Functions | |||
Determining Dates Within A Calender | Excel Worksheet Functions | |||
Cell right next to colored cells is automatically colored on entering a value | Excel Programming |