Need skip weekends from date series

[hasin]

Hello all,
I have sheet with date and all data,
Like A1 have date 5-1-08
Then A21 " I am using formula =A1+1 " , and A41 "A21+1" and so on for the month. My problem is I want skip weekends dates. ANY HELP? THANKS

[daddylonglegs]

Using WORKDAY function from Analysis ToolPak addin

=WORKDAY(A1,1)

or without the add-in, assuming A1 always contains a weekday,

=IF(WEEKDAY(A1)=6,3,1)+A1

[hasin]

Thank you daddylonglegs,
Your 1st formula working good, Now I have problem is My A1 cell follow Date from sheet1 "Sheet1!A2" ??, How can I use formula to skip weekend from Sheet1 date. Thanks

[hasin]

Some one help? for post