If statement

[sansan88]

Hi,

Hope someone can help me out here! See below Many thanks :-)

Excel Column
A1- Employee Hiring

i need a formula to pick out the starter of a particular month

for example

Hiring Date Headcount Month Formula?

01/03/2017 Jan-17 NO
01/01/2017 Jan-17 Yes (its this is a Jan-17 starter)
04/01/2017 Jan-17 Yes (its this is a Jan-17 starter)
15/04/2017 Jan-17 NO

[Phlegon_of_Tralles]

Please upload a worksheet with dummy information on it so that we can use it.

[CAntosh]

If I'm understanding the objective correctly, and your hire date is in A2 and your search month is in B2, then try the formula below in C2:

=IF(EOMONTH(A2,0)=EOMONTH(B2,0),"Yes (this is a "&TEXT(B2,"MMM-YY")&" starter)","NO")

Fill it down for the other entries. Take a look at the attachment to see if it'll work for you:




NOTE: Please also change your thread title to make the title a bit more descriptive and "search-friendly". Something along the lines of "If statement comparing two months", perhaps?

[sansan88]

Thank you so much CAntosh :-) all work perfectly!! Star :-)

[CAntosh]

My pleasure, good luck!