excel man

[Excelman]

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.

 

[Sandy Mann]

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

[email protected]
[email protected] with @tiscali.co.uk

 

[daddylonglegs]

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