I am trying to create a function which calculates if an employee is active in a certain month, I have the start date and only have an end date if the employee has resigned.
The function I have been working with is not working - Can anyone help?
[April 25]1 - This is the cell where the date I am checking against is held
[Original Hire Date]@row - This is the cell where the employee start date is held
[Term Date]@row - This is the cell that holds the 'Termination Date' if there is one
=IF( AND( [Original Hire Date]@row <= EOMONTH([April 25]1, 0), OR( ISBLANK([Term Date]@row ), [Term Date]@row >= DATE(YEAR([April 25]1), MONTH([April 25]1), 1))), 1, 0)
Many thanks.
