Forum Discussion
Solved
Allocate integer values over specified months
Hi all, I have a table in Excel that has a start date and an end date. I need to allocate a unit value spread over the months between the two dates. However I can only have whole units only, and ...
See the attached example. I changed the values in F1:Q1 to dates.
See the attached example. I changed the values in F1:Q1 to dates.
HansVogelaar this is absolutely perfect! I've been scratching my head for a week trying to figure this out! I've modified the formulas to work in a table, and stripped the EOMONTH as Sharepoint Lists doesn't support this functionality, (replaced with a DATE formula that adds a month and subtracts a day to get the end of the month).
Thank you for the speediest reply!