Excel formula

  • Thread starter Thread starter aviationmech
  • Start date Start date
A

aviationmech

Can anyone help with a formula I have been working with? Now I have a
spreadsheet with a workday formula that does not count weekends or holidays.
How can I include Saturdays?
 
Hi,

can't remember who I'm plagarising here so apologies and credit to the
original author.

=SUMPRODUCT(--(COUNTIF(C1:C8,ROW(INDIRECT(A1&":"&B1)))=0),--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)),3)<6))

Where
A1= start
B1 = End
C1 - C8 are holiday dates

Mike
 
forgot to add SUM, sorry

=SUM(IF(WEEKDAY(A1:A100,2)<7,A1:A100,))

this is an array formula so CTRL+SHIFT+ENTER it
 
Mike, What I am looking for is a formula where I can put a start date in say
A1 and the formula I put in A2:A? will auto fill the next dates excluding all
Sundays and Holidays. The formula I use now excludes the holidays I have
listed from another sheet.
 

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 to shift a weekend date to the last or next workday 2
Date formula that will return proper pay day 4
Date + X days excluding holidays 1
Calculating dates to include Saturdays but not Sundays 1
How do you count work days excluding weekends and holidays? 2
Workday Formula? 6
Schedule to exclude weekends and holidays 3
Adding weekdays in a date formula 2

Back
Top