Multiple conditions in excel to return yes / no

[Syrius]

Hi all,

I hope you can help me. I am trying to get a yes / no value in the current conditions. I need to get a yes if the date (H2) is 8 months or over and equal to or under 12 months of the date(F2)and a no if the date (H2) is over 12 months. I currently have this on the go but I'm getting some false negatives. Any help would be much appreciated!

=IF(AND(MONTH(H2)<=(MONTH(F2+12)),MONTH(H2)>=(MONTH(F2+8))), "Yes", "No")

 

[FDibbins]

Try something likethis?
IF(AND(H2<=edate(F2,12),H2>=edate(F2,8)), "Yes", "No")

 

[Syrius]

You are seriously a goddess! Thank you!

 

[FDibbins]

hehe happy to help (Im a guy though *g*)

 

[Syrius]

I really appreciate it, its been driving me nuts tying to figure it out! Obviously I was over complicating it.

 

[FDibbins]

no problem. EDATE() and EOMONTH() are 2 functions that can be quite handy when working with date comparisons