Calendar formula

[TinLizzy]

Hi,
Someone who knows Excel well prepared this Calendar for me that relates to a couple of other documents. It was years ago and has worked but even older copies have the same problem, but the dates are wrong.
There is a problem beginning in March that changes the whole thing after that.
Here is the offending formula, which means nothing to me. I just need someone to fix it. It is for Monday in March
=IF(Q8<>"",Q8+1,IF(I$13>=28,1,IF(I$12>=28,1,"")))

I have attached the document.
Thank you so much for any help.

[jason.b75]

Could you explain what you think is wrong with the dates?

I can see no differences between the dates it shows and those on any other calendar.

[TinLizzy]

You are right! It didn't show properly when I first opened it. Thanks for noticing that.
But why are there triangles showing a problem with the formula? That's why I thought there was something wrong and I don't think March showed up correctly to begin with. But it does now.

[TinLizzy]

I was quick to reply. March with the errors, is actually the right dates, but April is wrong and all thereafter.

[bebo021999]

See attachment.

[bebo021999]

I was quick to reply. March with the errors, is actually the right dates, but April is wrong and all thereafter.

K2 can be changed to other year, and leap year can turn below formulas incorrect:
Q6 (March) = I6+29
Q8 (first day of March):=IF(I12<>"","",IF(O12>=28,1,""))

[jason.b75]

I see the problem now, I even compared your calendar to another one and still missed it before.

And I'm supposed to have an eye for detail (don't tell my boss)

That's what happens when you let the cleaner do the job

This version uses proper date functions rather than the methods used in your original which, as you discovered, isn't 100% reliable. Also it does away with all of that garbage at the top, you don't need to tell it when it's a leap year, or what day the week starts, it will already know that from the start date. Just enter the start of year in A6 and you're good to go.

TinLizzy Calendar.xlsx

[mahju]

Try this one

Please Login or Register  to view this content.