Forum Discussion
Sum from cell across multiple sheet, depending on hire date
I have been testing the formula and it all works great except that it doesn't take into account the timesheet date in M4, it seems to be counting past the anniversary date.
For example, if I date the timesheet 10/1/24 in cell M4, Employee 1 still has a vacation time counted when it should have restarted on 11/11/24.
I think I figured out a way to have it work (attached). It's a roundabout way but seems to work.
Are you willing to post an actual workbook that replicates the way your real one is organized. Include at least two employees but not real names (e.g., Mickey Mouse, Donald Duck, etc), no real Soc Sec Nos, etc. It would make it a lot easier for us to help you if we could see what you have rather than work from your verbal description.
Let me add a postscript to my request for a sample workbook: I ask as a person who was the Director of the HR/compensation database for a major corporation back during my working years (retired now). I have a hunch that you might benefit from rethinking how you've designed your workbook. I may be wrong but either way, you'd be helping us help you by showing us how you've approached this overall task.
I am limited on how it's structured since I am using actual timesheet that get submitted each week. I am not able to modify the format on those.