excel man

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
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))))
 
Back
Top