FMLA Leave plus sick and vacation accrual calculator

Hi All

I'm attempting to create a tracking worksheet for FMLA usage that also calculates the accrual of both sick and vacation time.

I'm not sure if this would be better suited with VBA or if this could be accomplished with Excel formulas.

For each pay period, I need to have the spreadsheet calculate how much sick time will be used and how much vacation time will be used. This must also include any accrued sick and vacation time. And in the event that the employee uses all of the sick and vacation time they have available (to start and with accruals), then leave without pay (FML) will need to be calculated.

I hope someone can point me in the right direction.... I've been beating my head against this for days now.

I'd be happy to clarify if anything is unclear.