Nested IF statements with dates

See attached.

I'm getting lazy with my posts. I think the last three have just said "See attached".

Please Login or Register  to view this content.

The workbook is attached to this post with an explanation. Above is the full formula, if anyone wants to look it over and possibly make improvements.

mew!

EDIT:
Alright alright, sorry...
I'm assuming this is a sort of accounts receivable tracking system, since this is how ours works. It takes the first month at face value only if it's after the 16'th, and the second month at face value only if it's before the 16'th. Makes adjustments to the months if they fall outside those criteria. Subtracts the year values, and the resulting month values, to return the final month-difference answer.

Note the cells must be in DATE format, since the formula sources from DAY, MONTH, and YEAR values, which will not be recogized if they're not listed as such. You didn't really state how you were planning on listing your dates, but I felt that was a safe assumption.

mew!

Originally Posted by mewingkitty

See attached.

I'm getting lazy with my posts. I think the last three have just said "See attached".

Please Login or Register  to view this content.

The workbook is attached to this post with an explanation. Above is the full formula, if anyone wants to look it over and possibly make improvements.

mew!

Though it would be nice to have some explanation here so that when one opens the workbook, they can understand where to look or why it works as you designed it...