1 of 1 people found this helpful
It looks as though you only need to add a second step into your calculation maybe focussing the source to the first week and then identifying the Sunday.
First week would be
Day(Date) >= 1 And Day(Date) <=7
And now for the day
So I would expect your calc logic to be something like
If Month(Date) = 12 And (Day(Date) >=1 And Day(Date) <=7) And DateName('weekday',Date) = 'Sunday' Then Year(Date)+1 Else Year(Date) End
Note, I placed the week check into its own sub calc to enable this to be evaluated separately.
Thanks Steve. It works.
Glad to be of help.
Please can you mark this thread as answered as well.
To prevent this from continuing to pop-up as not answered, please can you mark this as answered / correct.