Here's my formula for D/M/Y where Y=YYYY=CCFS (CC=century digits F=First S=Second digit of the last two digits in year) Note:Only for Gregorian calendar. Formula= {D +Table(M) -1 IF month=1or2&leap_year +Table(CCmod4)…
Here's my formula for D/M/Y where Y=YYYY=CCFS (CC=century digits F=First S=Second digit of the last two digits in year) Note:Only for Gregorian calendar. Formula= {D +Table(M) -1 IF month=1or2&leap_year +Table(CCmod4)…