Formula for increasing dates by a value requied

[Jana55]

I need help with a formula that will take a date in a cell and add for example 3 days to the date and display the answer in date format.

For example:

Cell B1 has a date of (01/05/11)
In Cell A2 have 3. I want to display in cell B2 the date (04/05/11) sum of B1 plus 3 days hence.

If possible I would like the calucation to only display week days.
My formula experience is limited can anyone suggest a solution for me?

Kind Regards

Jana

 

[VoG]

Try

=WORKDAY(B1,A2)

In Excel 2003 and earlier you need the Analysis Toolpak from Tools > Add-ins.

 

[GlennUK]

How about:

=WORKDAY(B1,A2,Holidays)

... assuming that you have a named range of the holidays that you want to skip. The WORKDAY function is is part of the Analysis Toolpak, which you'll need to add-in if you are using a version of Excel before 2007 ( Tools/Add-Ins ).

 

[Jana55]

Perfect thank you Peter