This may sound odd... I'm building a document with an annual calendar that the user can update for any year.

I'm building the February Calendar, and I have determined a check for leap years, 0 for false 1 for true, bookmarked as Leap2.

I'm now down to the bottom row of the month. I want something that similar to the following, given that G8 = 28 and Leap2 = 1:



{ IF {=G8 }>= 28
{ IF {=AND({=G8}=28, {=Leap2}=1)}=1 {=G8+1} "" }
{ IF { =G8} 0 {=G8+1} "" }
}

Now, my issue is purely with the syntax of using AND in this capacity. If this formula doesn't make sense, I'd appreciate a few examples of table formulas using IF and AND.

Thanks in advance!