By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
A simple small formula for finding working days between two days (i.e. days excluding holidays and weekends.)
1) Holidays are populated from a view named holidays;
2) date range arrived by exploding;
3) Holidays in the date range replaced with null value , resulting in all days in the range except the holidays;
4) Next step is to remove all weekends ;using @weekdays and removing 1's and 7's(sun=1 and sat=7)
*FROM and TO are two date fields*
FIELD holidays:=@Dbcolumn("":"NoCache";"";"Holidays";1); FIELD dateRange:=@Explode(@TextToTime(@Text(FROM)+"-"+@Text(TO))); FIELD wkgDaysWithWE:=@Weekday(@TextToTime(@Trim(@Replace(dateRange;holidays;NULL)))); @Elements(@Trim(@Replace(@Text(wkgDaysWithWE);"1":"7";NULL))); OR use this one liner ;-) @Elements(@Trim(@Replace(@Text(@Weekday(@TextToTime(@Trim(@Replace(date