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

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
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
981
shawnbull
S
R
  • Solved
Overtime based on weekends AND holidays
2
Replies
12
Views
681
rockson
R
zoharb
  • Question
more Question to the thread-Using IFS to calculate a task due by date but needing to remove weekends
Replies
0
Views
183
zoharb
zoharb
J
  • Solved
Skipping unprotected cells
Replies
2
Views
194
JimM
J
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
2K
Romy
R

Forum statistics

Threads
1,222,017
Messages
6,163,409
Members
451,835
Latest member
kristianb63

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