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.

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.

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.