Formula to check if Year & Month are the same.

[howardJennings]

I have a complicated spread sheet which calculated insurance premiums. part of the sheet calculated the 'billing period'
it's pretty simple
IF the 'Effective Date" is this before the invoice date billing period = number of days in the month
ELSE Billing period is Number of days in the month LESS the 'Effective Date".

I have to check whether the 'Effective Date" YEAR & MONTH are the same as the 'Billing Date' YEAR & MONTH (i'm ignoring the day). The formula I'm using to do this is

=IF(AND(YEAR(H10)=YEAR($E$3),MONTH(H10=MONTH($E$3))),"TRUE","FALSE")

Cell H10 & E3 contain the date that i need to check.

The formula works once or twice and then stops, what have i done wrong?

 

[NeonRedSharpie]

What do you mean "stops"?

 

[howardJennings]

CELL E3 is the fixed date to reference

CELL H10 is the cell you'd enter the "effective Date' in

the first time i enter a date in H10 the formula calculates correctly and displys either 'TRUE" or "FALSE"

however it's hit or miss whether it will calculate correctly again if i change the date in H10

 

[howardJennings]

DOH! I've just noticed a missed ')'

Bugger!

 

[MarcelBeug]

If you want real TRUEs and FALSEs instead of strings "TRUE" and "FALSE", you can shorten your fomula to

=AND(YEAR(H10)=YEAR($E$3),MONTH(H10)=MONTH($E$3))