adding up a part timers days in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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......
 
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.
 
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
 
Back
Top