Can an add function be tweaked to compute a date value that does not equal a
Saturday or Sunday.

Example:
Start date = 4/17, days added = 2, answer = 4/19 which is a Sunday.
Desired answer is 4/20 which is a Monday.

Try this:

A1 = 4/17/2009
B1 = 2

If the result you expect is Monday then that means you're counting the start
date.

=WORKDAY(A1-1,B1)

Format as Date

The WORKDAY function requires the Analysis ToolPak add-in be installed in
Excel versions prior to Excel 2007.

--
Biff
Microsoft Excel MVP


"brownmre" wrote in message
...
Can an add function be tweaked to compute a date value that does not equal
a
Saturday or Sunday.

Example:
Start date = 4/17, days added = 2, answer = 4/19 which is a Sunday.
Desired answer is 4/20 which is a Monday.

Try
=A1+2+IF(WEEKDAY(A1+2,2)5,8-WEEKDAY(A1+2,2),0)
with Start date in A1

"brownmre" wrote:

Can an add function be tweaked to compute a date value that does not equal a
Saturday or Sunday.

Example:
Start date = 4/17, days added = 2, answer = 4/19 which is a Sunday.
Desired answer is 4/20 which is a Monday.

Look in Excel help at the function WORKDAY
--
David Biddulph

"brownmre" wrote in message
...
Can an add function be tweaked to compute a date value that does not equal
a
Saturday or Sunday.

Example:
Start date = 4/17, days added = 2, answer = 4/19 which is a Sunday.
Desired answer is 4/20 which is a Monday.

Thanks Sheeloo. It works great.

"Sheeloo" wrote:

Try
=A1+2+IF(WEEKDAY(A1+2,2)5,8-WEEKDAY(A1+2,2),0)
with Start date in A1

"brownmre" wrote:

Can an add function be tweaked to compute a date value that does not equal a
Saturday or Sunday.

Example:
Start date = 4/17, days added = 2, answer = 4/19 which is a Sunday.
Desired answer is 4/20 which is a Monday.

You are welcome.

Try Biff's solution too... it is more elegant.

=WORKDAY(A1-1,2)
or

=WORKDAY(A1,2)

"brownmre" wrote:

Thanks Sheeloo. It works great.

"Sheeloo" wrote:

Try
=A1+2+IF(WEEKDAY(A1+2,2)5,8-WEEKDAY(A1+2,2),0)
with Start date in A1

"brownmre" wrote:

Can an add function be tweaked to compute a date value that does not equal a
Saturday or Sunday.

Example:
Start date = 4/17, days added = 2, answer = 4/19 which is a Sunday.
Desired answer is 4/20 which is a Monday.

It depends on what their exact requirements are.

Our formulas return different results depending on the weekday of the date.

--
Biff
Microsoft Excel MVP


"Sheeloo" wrote in message
...
You are welcome.

Try Biff's solution too... it is more elegant.

=WORKDAY(A1-1,2)
or

=WORKDAY(A1,2)

"brownmre" wrote:

Thanks Sheeloo. It works great.

"Sheeloo" wrote:

Try
=A1+2+IF(WEEKDAY(A1+2,2)5,8-WEEKDAY(A1+2,2),0)
with Start date in A1

"brownmre" wrote:

Can an add function be tweaked to compute a date value that does not
equal a
Saturday or Sunday.

Example:
Start date = 4/17, days added = 2, answer = 4/19 which is a Sunday.
Desired answer is 4/20 which is a Monday.