Hello,
I am trying to figure out a way to calculate months in columns without exceeding a specified number of days. Example:
Person A starts - 8/15/16 - Allocate partial month; full month; full month; allocate partial month
Person B starts - 8/1/16 - allocate full month; allocate full month; allocate full month
Person C starts - 9/21/16 - etc.
The specified number of days is 90. I need to allocate say 100,000 for each of them over the 90 days where it prorates the beginning month and ending month if it isn't a full month but spreads the full months evenly and not using number of days in the month where the full month of January would not equal the full month of February due to less days in February. It would need to stop calculating at 90. However, one person may get set to 120 days and another at 60 days. I am trying not to use VBA in this case to make it a simple workbook. It is for another person to use and didn't want to get into the VBA maintenance with them.
Bookmarks