Just like your proposed AddWorkDays !! <bg

Pete

Bob Phillips wrote:

=WORKDAY(A1,7)



"Joe_Germany" wrote:

One more qn ..
the help for WORKDAY says that the date has to be entered with DATE
function..

If i have a date in a cell, how I can use that directly to this fn,
rather than extracting year, month and date from that & in turn use
that in the DATE function for this..

Thanks a lot..