excelquestioner123
New Member
- Joined
- Feb 24, 2021
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
I am trying to make a formula based on if someone replied in the month. So if the name is listed anywhere on the sheet but the date in the same row in December for example. I have tried everything from the Month function to greater than less than function.
=IF(AND('DATA INPUT'!$A:$A='Observers'!$A2,MONTH('DATA INPUT'!$B:$B=MONTH(12))),"Yes","No")
=IF(AND('DATA INPUT'!$A:$A='Observers'!$A24,('DATA INPUT'!B:B>"11/31/2020"),('DATA INPUT'!B:B<"1/1/2021")),"Yes","No")
=IF(AND('DATA INPUT'!$A:$A='Observers'!$A2,MONTH('DATA INPUT'!$B:$B=MONTH(12))),"Yes","No")
=IF(AND('DATA INPUT'!$A:$A='Observers'!$A24,('DATA INPUT'!B:B>"11/31/2020"),('DATA INPUT'!B:B<"1/1/2021")),"Yes","No")