Tracking Paid Time Off in excel

[jdgreen]

I am attempting to create a formula to track my accured paid time off.

I accumulate 4.62 hours bi-weekly. the dates are as follows:

3-Jan, 17-Jan, 31-Jan, 14-Feb, 28-Feb, 14-Mar, 28-Mar, 11-Apr, 25-Apr, 9-May, 23-May, 6-Jun, 20-Jun, 4-Jul, 18-Jul, 1-Aug, 15-Aug, 29-Aug, 12-Sep, 26-Sep, 10-Oct, 24-Oct, 7-Nov,
21-Nov, 5-Dec, 19-Dec.

Please respond if you can help.

Thank you,

JD Green

[alansidman]

Is this helpful. See attached.

[Xx7]

Try this..