Leap Year Error Value

Hi everyone,

I am having trouble to auto populate March if February is on a Leap Year. I am using a formula where 29 will show up if it's a Leap Year and it won't show if it's not a Leap Year.

Now the problem is if it's not a Leap Year then the March will show error looking for a Value.

Please see attached screen shot.

Thank you very much in advance and appreciate your help.

Capture101.JPG

Do you need to have a gap there if it is not a leap year?

If so, then you could test for BP2 being a space and increment BO2 instead if it is, i.e. in BQ2:

=IF(BP2="",BO2+1,BP2+1)

Hope this helps.

Pete

Hi Pete,

Thank you very much. This worked.

Kind regards,
Jay

Hi bebo021999,

Thanks for the help. Haven't tried your formula but will keep it too just in case :-)

Kind regards,

Jay