Forum Discussion

ahxl's avatar
ahxl
Regular Visitor
8 years ago

Calculating time between a date and today - excluding weekends and holidays (need to pick dates)

Hi all   I have so far been using the following formula to calculate the number of days beteween a specified date and todays date EXCLUDING weekends.   COLUMNAge = VAR StartDate = DATE(2017,1,1) ...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

I assume you already have a calendar table, o add new field to flag holiday in calendar table and then update your formula to exclude those dates.

ahxl's avatar
ahxl
Regular Visitor
8 years ago

Hi Parry

 

I dont have a seperate calendar table, but I believe the above formula creates a calendar table when it is executed? The part I am struggling with is in the above formula, adding in a portion to exclude specific dates...