sandeep_sarkar
New Member
- Joined
- Aug 10, 2020
- Messages
- 7
- Office Version
- 2010
- Platform
- Windows
Dear Mr Excel Forum,
Greetings. Hope all is going well.
Like to take your advice. I entered this formula in cell F2 : =MONTH(B2:D2)&YEAR(B2:D2)=MONTH($G$1)&YEAR($G$1).
But it is not working after pressing ctr+shift+enter.
Whatever month & year I type in G1 [say Sep-20] it will show TRUE or YES beside the names in Column F.
Please help.
Sandeep
Kolkata
Greetings. Hope all is going well.
Like to take your advice. I entered this formula in cell F2 : =MONTH(B2:D2)&YEAR(B2:D2)=MONTH($G$1)&YEAR($G$1).
But it is not working after pressing ctr+shift+enter.
Whatever month & year I type in G1 [say Sep-20] it will show TRUE or YES beside the names in Column F.
Please help.
Sandeep
Kolkata