DeletedAccount918
Board Regular
- Joined
- Apr 14, 2009
- Messages
- 52
Hi,
I have done sheet with timeplan in excel book (for clients who do not have MS Project).
Now I need help with IF function (which is getting me crazy all the time!). The timescale it set for 2 weeks interval, the cell should be always colored when there is any entry for those dates (e.g. when there is just activity on July 6, the whole column July 1st - July 15 th will be colored).
I used conditional formatting for coloring, so I need just to have 1 or 0 to be written in the cells.
Unfortunatelly my formula is not working when the date is the last day in the month...
I would very much appreciate if you have any tips for how to improve my formula (or to rework it completely).
If my instructions were not clear you can check print-screen here: http://www.clichy.estranky.cz/fotoalbum/umelecke-pokusy/smeska-starsich-fotografii/original/77
Thanks!
T.
I have done sheet with timeplan in excel book (for clients who do not have MS Project).
Now I need help with IF function (which is getting me crazy all the time!). The timescale it set for 2 weeks interval, the cell should be always colored when there is any entry for those dates (e.g. when there is just activity on July 6, the whole column July 1st - July 15 th will be colored).
I used conditional formatting for coloring, so I need just to have 1 or 0 to be written in the cells.
Unfortunatelly my formula is not working when the date is the last day in the month...
I would very much appreciate if you have any tips for how to improve my formula (or to rework it completely).
If my instructions were not clear you can check print-screen here: http://www.clichy.estranky.cz/fotoalbum/umelecke-pokusy/smeska-starsich-fotografii/original/77
Thanks!
T.