Calclation based on current date

[it's an excel world]

Hi all,

I have a question about calculating days from the current date.

I have a sheet in which cell A1 is set up to display "today" date. In cell A2, I would like a formula that would calculate and display the date 20 days out from the "today" date. However, if the 20th day is a Saturday or Sunday, I want it to display the following Monday's date (21st or 22nd day). The calculation does not need to factor in weekends in between, only if the 20th day fall on Sat or Sun.

Thanks is advance!

 

[Scott Huish]

Prior to XL2007, you will need to load the Analysis Toolpak for this:

=WORKDAY(A1+19,1)

 

[it's an excel world]

Thank you!!!!