Vacation Tracker

  • Thread starter Thread starter JEB
  • Start date Start date
J

JEB

I need some help. I am trying to build a simple vacation tracker for the
office. I have built a small calender with each cell as one day in the year.
For each employee I am entering a "V" for when they take a vacation. I have
used the "count" funtion, which works great if the employee schedules a full
day of vacation. If I need ".5V" for a half day of vacation, I cannot add
this to my count for the number of days taken by the employee. Is there some
function I can use to add up all of the "V" and ".5V" for the month to see
the vacation time taken.
 
Why not put 1 for a Vacation day, .5 for half a day, then just sum the
range?

Regards,
Fred
 
Hi Jeb
Try this =SUMPRODUCT(--(B1:Z1=".5v"))+SUMPRODUCT(--(B1:Z1="v"))
Change the range to your needs.
HTH
John
 
Back
Top