I have 2 related questions to ask:
1. I have a list of dates and I will want to set my next column(Workday) to 1 if the date is monday to saturday but 0 if the date is on a sunday like this:
Screenshot
2. I will like to set my WorkDay to 0 at sheet 1 if the date is a public holiday entered at sheet 2.
Sheet 1
Sheet 2
In conclusion, how am I suppose to write the formula for my workday(column) as shown that meet my 2 requirements stated?
Bookmarks