> Change the formula in C1 to the following:
>
[quoted text clipped - 12 lines]
> > in as i have copied the formula down the cells of column C
> > any ideas???
thank you so much
although this solved the above problem, it has now caused another problem,
my fault i did not say what i was working on, i have created a gantt chart
in excel
and use the start and end dates to calculate work progress and for every day
counted in the end date, a designated cell will be highlited through out the
month.
the above formula you have sent has caused the whole of the month to be
highlited,
what i want is for the whole range of cells for that month to also remain
blank until the start date is entered.....
WLMPilot - 06 Dec 2007 11:40 GMT
Still not sure what you are trying to do. Can you explain the "range of
cells" by using cell examples and what they are to do. I may be able to help
you better then.
Also, explain your original formula: What is the qty of days and how do you
determine that value. Also, why is "1" added to the formula?
Thanks,
Les
> > Change the formula in C1 to the following:
> >
[quoted text clipped - 23 lines]
> what i want is for the whole range of cells for that month to also remain
> blank until the start date is entered.....