Calculate Date
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.
|