Please see attachment, I'm trying to automatically populate columns with the correct order of months, ensure they hit their 30/31 day max day count and for Feb (depending upon a leap year or not), reach 28 or 29 days. I'm a beginner, so struggling with how to add all of these formulae together! Basically:
If month in column A is Jan, Mar, May, Jul, Aug, Oct or Dec then don't let the count/number in column B be >31 (eg: months with 31 days).
If months in column A is Apr, Jun, Sep or Nov, then don't let the count/number in column B be >30 (eg: months with 30 days).
If the number in D2 is 1, 5 or 9 (based on the Chinese calendar) AND if month in column A is Feb, don't the number in column B be >29 (eg: a leap year), otherwise don't let it be > 28