Labor day formula

R

Richard

Does Labor day fall on the first Monday of September? If so how would you
write that formula? Thanks in advance!!!
 
A

Ardus Petus

If your assumption is true (which I don't know),
Say A1 holds 1/9/2006
=A1+MOD(7-WEEKDAY(A1,3),7)
will return first monday of september

HTH
 
K

Kevin B

The following formula should do the trick. It verifies that the day of the
week is a Monday, the month is September and the day of the month is less
than 8. The example below assumes that the date being evaluated is in cell
A1:

=IF(AND(WEEKDAY(A1)=2,DAY(A1)<=8,MONTH(A1)=9),TRUE,FALSE)
 
J

JLatham

To find when various federal holidays are observed, see this set of 'rules'.
There are 10 fed holidays, 4 are on fixed dates, 6 are variable. When a
federal holiday falls on Saturday, it is observed on the Friday before. When
it falls on a Sunday, it's observed on the Monday following.

http://aa.usno.navy.mil/faq/docs/holidays.html
 

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

labor day holiday formula 2
How to implement two shifts per day with multiple teams 0
locate a column, sum specific columns to the right of that column 3
Multiplying the number in one cell and providing the product in an 4
How to Shop Client delays in my ghantt chart so i can claim for delays 0
Excel formulas 2
2016 Project, adding a workday to custom field 0
IF statement with nested SUMPRODUCT? 3

Top