I need a formula that returns weekends and holidays for each mont

W

Witness

I have created a mileage log with each month having its own spreadsheet in a
workbook. The first sheet starts with February 2006 and the last sheet ends
with february 2007. There are 12 sheets in total. Each month start on the
first day and ends on the last day of that month. The calendar is South
African. How can I create a formula that shows a Saturday, Sunday and Holiday
per month. I have used =TEXT(A2, "ddd") to return days but I don't know how
to create a formula that also returns holidays.

Please help.
 

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

number of months and days between two dates without approximation 3
Need formula to calculate bi-monthly pay dates 5
Date formula that will return proper pay day 4
identifying the next working day after weekends and/or holidays 2
excel total days formula including weekends, excluding holidays 0
How to shift a weekend date to the last or next workday 2
IF Statement Using Dates 6
Formula to check if a date is a holiday 5

Top