I'm working on a formula in Excel, to make sure the logic is correct -- but eventually I would like to put it into a LiveCycle Designer form.
We count the actual number of months between two dates to calculate retention points for employment layoffs. If you work 15 or more days in a month, the month is counted. So, assuming non-leap year, if the start date is February 10, then February should be counted. If the start date is February 20, then February should not be counted. Most standard functions assume 30 day months, and I need to be able to include that =>15 calculation to the beginning and end date.
Cell A2 - Start date
This is entered by the user
Cell B3 - Last day of the start date
Cell C3 - # days in start month
Cell D3 - Returns "1" if start month should be counted
Cell E3 - End date
Cell F3 - Last day of end month
Cell G3 - # of days in the end month
Cell H3 - Returns "1" if end month should be counted
Cell I3 - # of whole months between start and end date