Correct MONTHTODATE() for Gregorian calendar

Options
gazwillott
gazwillott Member, ALL USERS, Community Member Posts: 5 Contributor
in Planning & Modeling

Hi,

 

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.

 

Thanks,

Tagged:

Comments

  • gazwillott
    gazwillott Member, ALL USERS, Community Member Posts: 5 Contributor

    Amazing. Works a treat. Thanks very much 🙂

Categories