Calculate Date

[brownmre]

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.

 

[T. Valko]

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.

 

[Sheeloo]

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

 

[David Biddulph]

Look in Excel help at the function WORKDAY

 

[brownmre]

Thanks Sheeloo. It works great.

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

 

[Sheeloo]

You are welcome.

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

=WORKDAY(A1-1,2)
or

=WORKDAY(A1,2)

 

[T. Valko]

It depends on what their exact requirements are.

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