I have created a monthly schedule and the people are on call 15 days then off 3. How can I get Excel to tell me what their next 3 days off are going to be if I input their 15th day of work? Is there a way it can do this for me for the rest of the your all at once? I am usually pretty good with Excel, but this really has me stumpped!!! Thanks in Advance your your help.

B1- Person's name

B2- their 15th day of work

B3- This is where I will put any vacation for the month they have requested off (Vacation will just be a number, like "3" for the amount of days off they have requested) It would be nice to be able to find some way to have the option of putting the days before and/or after their scheduled days off, depending on what they have requested and do that without messing up thier scheduled days off. For example, if they have Jan 13, 14, and 15 scheduled off and they want to add 5 days to that for vacation, after they got back on the 20th, their next set of days off would be 10 days from then, not 15 because the vacation does not count against their scheduled days off. Hope that makes sense!!!

B4- This is where I want Excel to tell me their next 3 days off (along with vacation if they have requested it)

Finally, if their is an easier way of doing all this other than the format I have set up, by all means please do not be bashful.

Thanks in advance for your help.