Note: In order to use the spreadsheet examples, you need to download Business Functions
|Occurs (Time, Base, EventDates)|
|Determine if an event occurs in a time period|
|This function returns TRUE if an event occurs within a timeperiod. The Business Functions library, when determining Inclusiveness, includes the first date of the timeperiod but excludes the last. So, for a time period of 3 months from 1st April to 1st J|
|Auto Array Function|
EventDates can either be a single date, in which case the function just determines if that event occurs, or it can be any number of dates, in which case the function determines if either or any of the events occurs in the time period.