Correct MONTHTODATE() for Gregorian calendar
Does anyone know how I can correct the MONTHTODATE() function when the model time is set to Weeks 5-4-4?
The function works perfectly apart from when the month changes during the week. With the current time settings, the second month cumulation starts earlier than it should because it is starting from the first day of the week in which the month has crossed over in rather than the 1st of the month.
Any help would be greatly appreciated.