adding up a part timers days in Excel

J

jon boy

Hi - Is there a way of Excel adding up certain weekdays from a date?

For example, if I chose Tue, Thu and Sat in cells A1 to A3, B1 holds date to
be counted from and then B2 showed 9 (the number of days to be worked), could
Excel add up B1 + B2 but only those days specified from Row A and give me the
last date as the answer in B3?

Is there a way of doing this without using the Analysis ToolPak......
 
J

JLatham

Can you lay out some sample data so people can get a visual on what you're
looking for? Maybe by seeing what you're talking about in more (visual)
detail, they can offer some help.
 
J

jon boy

How about
A1 Tue A2 Thu A3 Sat
B1 = 05/11/2007 (5th Nov) B2 = 9 B3 = B1+B2 sum only days from Row A

In the above example, cell B3 would return 24/11/2007 as the answer - sum
only the specified days in row A
 
Top