J
~Jeff~
Column A consists of dates (format example: Thursday, May 06). Date is
entered when vacation time or sick time is taken.
Column B consists of the hours of vacation for that day
Column C consists of the hours of sick time for that day
Column E consists of the months (January, February, etc.)
Column F consists of the hours of vacation taken for that month
Column G consists of the hours of sick time taken for that month
Can someone tell me what the formula would be for cells in columns F & G? I
imagine it would be some kind of lookup function or count function.
Thank you in advance
entered when vacation time or sick time is taken.
Column B consists of the hours of vacation for that day
Column C consists of the hours of sick time for that day
Column E consists of the months (January, February, etc.)
Column F consists of the hours of vacation taken for that month
Column G consists of the hours of sick time taken for that month
Can someone tell me what the formula would be for cells in columns F & G? I
imagine it would be some kind of lookup function or count function.
Thank you in advance