excel man

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Excelman - 19 Oct 2006 17:52 GMT

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.

Reply to this Message

Sandy Mann - 19 Oct 2006 19:06 GMT

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)

Signature

HTH

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

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk

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

Reply to this Message

daddylonglegs - 21 Oct 2006 19:33 GMT

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))))

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

Reply to this Message