If your question is refering to the MONTH function, it is b/c the month is given as an integer, ranging from 1 (January) to 12 (December). It's a Microsoft Excel thing. The DATEDIF function would work for counting months on dates that are outside the same year.
Hi 1204joey,
If your question is refering to the MONTH function, it is b/c the month is given as an integer, ranging from 1 (January) to 12 (December). It's a Microsoft Excel thing. The DATEDIF function would work for counting months on dates that are outside the same year.
dough517 1 month ago
can you explain why it doesnt count the number of month when you change the year?
1204joey 1 month ago