What formula do I use?
Let's say you record the vacation days in row #3:
7/15/2007 8/8/2007 11/5/2007
where a date is entered each time a day is used. The formula:
=COUNT(3:3) will tell you how many cells have been filled in this fashion.
--
Gary''s Student - gsnu200753
"MABuckeye" wrote:
I work for a small business and have created a spread sheet for each of the
employees tracking thier Vacation Benefit. Currently there is a row that
documents each day that a vacation day is used by the cell being formulated
for date. At the end of the row I have to manually enter the number of days
used. Is there a way for this cell to tally up the days automatically by
counting the number of cells with a date in it. I tried using Logic
functions like IF but I cant seem to get it to work. Any suggestions would be
greatly appreciated.
thank you
|