Date Ranges and IF statements

[mphillips]

Hello --

On a worksheet, in column E is a hire date and column F is a terminated date (row 2). Then columns G-BI are month/years.

I want Row2 Column G-BI to answer the question if the individual as an employee in a given month/year with a Y or blank.

How would I do this?

Attached is an example of how the layout and what I'd want it to look like.

[samba_ravi]

G2=IF(OR(G$1<DATE(RIGHT($E2,4),LEFT($E2,FIND("/",$E2)-1),1),G$1>IF($F2="",10^10,DATE(RIGHT($F2,4),LEFT($F2,FIND("/",$F2)-1),1))),"","Y")

Try this and copy across

[daffodil11]

G2:

Please Login or Register  to view this content.

Copy down and across

Edit: This is a bad answer.

[mphillips]

This seems to be working! I really appreciate your answer and help!!!

[Melvinrobb]

Another option.
AB2:

Please Login or Register  to view this content.