"Workdays"

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

Guest

I have colomn with start date(Column A), Column C = duration Column B =
Column a + Column C

I would like exclude Saturday and Sunday of the week

How can I do That?

Please Help
 
=WORKDAY(A1,C1)
you will need to have the analysis tool pak installed as an addin
Greetings from NZ
Bill K
 
Is it safe to assume that the duration in Column C is working days, and you want
Column B to be the date that is the number of Column C working days after the
start date?

If so, use the Workday function:

Column B =Workday(a1,c1)

You may need to load the Analysis Toolpak to access this function
(Tools>Addins...)
 

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

How do I calculate future date after number of days 1
Workday function question 2
Calculate workdays for irregular work patterns 1
How to calculate the number of Workdays for irregular work pattern 1
Future date with six day week including holidays 1
Date Calculation Formula- Calendar days minus Holidays 1
How to make Friday as weekend instead of Sat/Sun in Workday Functi 11
Determining the Sunday date of the third "full" weekend of a month 25

Back
Top