excel man
 

I need to calculate dates, with Sunday (only) being skipped. Example: I want
to enter a date in a cell, and have excel add 5 days to it, skipping over
Sunday (if needed) and print the result date in another cell.

excel man
 

Excelman,

If you mean add 5 days and if that lands on a Sunday add another day then
try:

=A1+5+(WEEKDAY(A1+5)=1)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Excelman" wrote in message
...
I need to calculate dates, with Sunday (only) being skipped. Example: I
want
to enter a date in a cell, and have excel add 5 days to it, skipping over
Sunday (if needed) and print the result date in another cell.

excel man
 

If you want to add the number of working days in B1 to a date in A1, with
working days being defined as all days except Sundays

=A1-WEEKDAY(A1,3)+INT(7/6*(B1+MIN(5,WEEKDAY(A1,3))))

"Excelman" wrote:

I need to calculate dates, with Sunday (only) being skipped. Example: I want
to enter a date in a cell, and have excel add 5 days to it, skipping over
Sunday (if needed) and print the result date in another cell.