ExcelBanter - chose days by month

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - chose days by month (https://www.excelbanter.com/excel-discussion-misc-queries/155040-chose-days-month.html)

chose days by month

I would like to write a function that is different for each month. My dates
are written in dd/mm/yy format. i am looking for a way to reference the
specific cells in a month without referencing day by day. For example i
would write an IF statement like =IF(A1=(SOME DAY IN MARCH?),A1,"". Can
anyone help? I am familiar with arrays and most functions i am just unsure of
what to use. Thanks
A
1 3/3/2006
2 4/4/2006
3 3/16/2006
4 5/2/2006
5 4/29/2006
6 2/2/2006

chose days by month

One way:

=IF(MONTH(A1)=3,A1,"")

In article ,
Dave wrote:

I would like to write a function that is different for each month. My dates
are written in dd/mm/yy format. i am looking for a way to reference the
specific cells in a month without referencing day by day. For example i
would write an IF statement like =IF(A1=(SOME DAY IN MARCH?),A1,"". Can
anyone help? I am familiar with arrays and most functions i am just unsure of
what to use. Thanks
A
1 3/3/2006
2 4/4/2006
3 3/16/2006
4 5/2/2006
5 4/29/2006
6 2/2/2006