hi
I'm using the below formula to get dates everytime should I change the year but it's coming up as 01/01/1900.
How can I resolve it. Transition entry check is not ticked as well.
=TEXT(Year!A4, "mm/yyyy")+MOD(8-WEEKDAY(TEXT(Year!C2,"mm/yyyy"),2),7)
many thanks
Bookmarks