Spreadsheet rules adding consecutive years every 30 lines

I don't know how a calendar like that would look. I suppose the calendar template can be reworked so all months have 30 days but I don't know if that suits your purpose or would be useful for anything. I feel it would be very odd. Most days would not correspond with the days in the actual calendar.

There are apparently several variations of ancient 360-day calendars. If you have one in mind, show us what it is.

There are several variations of doing financial calculations based on a 360-day year but none of those financial methods appear to actually use a 360-day calendar, they are adjustments to duration calculations between days. I'm not even sure if the financial adjustments can be made into a 360-day calendar because what you do to translate the actual days into the 360-day calendar depends on both days you are looking at. Sometimes one of the two dates will get adjusted, sometimes both, sometimes neither.

Hi Mathew,

Thanks for the clarification, but I am still unsure! Does the Jubilee occur every 49 years, or every 50 years?

The MOD function might be what you want.

The MOD function returns the remainder from a division. Both arguments are number values.

MOD(dividend, divisor).

Assuming Jubilee is every 50 years, MOD(50,50) equals zero and MOD(100,50) equals zero.

All we need to do is test the year on every row of your table to see if the MOD of 50 is zero.

Here is a very short version of your table:

Formula in C2: IF(MOD(B2,50)=0,"Jubilee Year","")

Adapt the formula for a 49 year cycle.

Please reply with questions or further clarification.

Regards,

Ian.