I need a formula to calculate the number of days between hire date and the last day of the previous month.
For example: If I were to run the report today (May 10), it would count the number of days between hire date and April 30th. No matter when I run the report, the count should always use the last day of whatever the previous month was.
Any assistance would be greatly appreciated. Thanks