Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Holidays


Jeremy

Recommended Posts

When calculating workdays, what is the best way to also calculate holidays?

 

I have a separate database setup called holidays with all the holiday in it.

Link to comment
Share on other sites

Cobalt Sky probably has a genius calculation to do this, but I would try it through a calculation which excludes specific dates (holidays) and any days which equal Saturday or Sunday. For Instance:

 

Case(Month(DateField) = 1 and Day(DateField) = 1 or Month(DateField) = 12 and Day(DateField) = 25 or (etc., etc., etc.),

0,

 

DayName(DateField) = "Saturday" or DayName(DateField) = "Sunday",

0,

 

1)

 

The first equation would eliminate all holidays with fixed dates such as above would eliminate New Year's Day and Christmas from the count. The second would eliminate all weekend days from the count. Frankly, I don't know to eliminate holidays such as Easter (which change dates every year).

 

Hope this helps and that perhaps someone else has a better solution.

 

Tom

Link to comment
Share on other sites

If you have a file for holidays set, use a relationship based on dates to that file and add an If(Is valid(yourHolidaysrel::Date) string to Tom's calc.

Link to comment
Share on other sites



×
×
  • Create New...

Important Information

Terms of Use