Auto populate calendar with Leap Year and Non-Leap year.

Hi everyone.

I am looking for a solution for this problem.

I am creating a sheet with auto populate dates on different sheets by entering the initial date which the starting date is January 1, YEAR.

The tabs are named by numbers (1, 2,3 until 12). Number 1 obviously is January and then the next sheet is number 2 which is February and then all the rest of the sheets are auto populated until December.

Everything is ok except if the year falls on a Leap Year.

I have a cell open until the 29 for February, but if it's not Leap Year then the cell that suppose to be blank is populated by March 1.

Is there any simple formula that will help me to solve this problem? I just want February to be automatically populated from 1 - 28 days and have the last cell available free or blank if it's not leap year rather than having March 1 in it, and automatically populate it with 29 if it falls on a leap year.

Appreciate all your help and response.

Regards

Hi popipipo

Appreciate your response. But I'm not just looking for calendar. I only need to populate 1 column and continuesly populate the next sheets on 1 column too.

Any other please? Thanks

Hi Glenn

Thanks for that. I was trying to attached the small workbook but it's not letting me to attached it. A picture is allowed instead. Will post a screen shot.

Regards

Hi

Here's a screenshot of the work book.

Thank you.Attachment 652779

Hi

I think I manage to attached the workbook in this post. Please let me know.

Thank you all.

put this formula in the cel for 29th

Formula:

Please Login or Register  to view this content.

the trick is that each leap year can divided by 4 without a remaining fraction.. so that is what the mod function is for to test is the remainder is 0 or not.

Hi everyone,

Thank you all so much for the support and help. I have now managed to get the answer. Roel Jongman and popipipo formula works.

Till next time.

Regards