I’m using the mod function as follows:

Mod(Date 1 – Date 2, 365), where date 1 is a fixed date in time (say 9/1/2010) and date 2 is last day of each month in the future (e.g., 8/31/16).

You’d think that the MOD function would give the exact same result for each month end date, right? Not so:


• =MOD(9/1/10-8/31/10,365)=1
• =MOD(9/1/10-8/31/11,365)=1
• =MOD(9/1/10-8/31/12,365)=0
• =MOD(9/1/10-8/31/13,365)=0
• =MOD(9/1/10-8/31/14,365)=0
• =MOD(9/1/10-8/31/15,365)=0
• =MOD(9/1/10-8/31/16,365)=364

Thoughts?