Dating using workdays

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

Guest

Is there a way to autofill dates into a spreadsheet and only use workdays and not Saturdays and Sundays?
 
Depending on version yes, put the first date in a cell, right click the cell
and copy it down,
when you release the mouse button you can select weekdays..
 
You could try this.

Put a non weekend-date in A1
Put this formula in A2 =IF(WEEKDAY(A1)=6,A1+3,A1+1)
Copy it down

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

K McGee said:
Is there a way to autofill dates into a spreadsheet and only use workdays
Click to expand...
and not Saturdays and Sundays?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

start date + net workdays = end date 1
How to shift a weekend date to the last or next workday 2
Conditional format> weekend 2
how do i force an value to "jump over weekends" 5
DATE WORKDAY PROBLEM 3
Networkdays 2
Date + X days excluding holidays 1
Workdays not working as expected 3

Back
Top