If the date is in A1, rather than a simple =A1+5

try =A1+5+(WEEKDAY(A1+5)=7)*2+(WEEKDAY(A1+5)=1)
--
Gary's Student


"JE McGimpsey" wrote:

Take a look at WORKDAYS() in XL Help. This is an Analysis Toolpak Add-in
function (Tools/Add-ins...)

In article ,
lkoyne wrote:

How do I calculate Dates (ie 10/11/05+5) to get only Week Days, not weekend
days??