autofill and skip all weekends

I

imported_unknown

Active Member
Joined
Jan 13, 2002
Messages
424
i am looking for the way to make a schedule by using auto fill and skipping all weekends.
This message was edited by zzw on 2002-10-05 19:47
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Sort by date Sort by votes
There are calanders as such that could be used on this one

Intrested i can email you something i got from ??? cant remember now!

HTH
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
WORKDAY.INTL does not block out holidays
2
Replies
13
Views
537
shawnbull
S
R
  • Solved
Subtracting all calendar days, but end date cannot fall on a weekend or holiday. If it does, the end date shifts to the preceding work day.
Replies
8
Views
214
Romy
R
Ramballah
  • Question
Huge nested IF or is there a simpler way?
Replies
4
Views
196
Ramballah
Ramballah
C
  • Question
Formula Result Change to next Workday
Replies
3
Views
303
Fluff
Fluff
Ramballah
  • Question
Need a formula that counts the shifts and gives me a total
Replies
2
Views
215
bobaol
B

Forum statistics

Threads
1,214,784
Messages
6,121,536
Members
449,037
Latest member
tmmotairi

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top