If formula help

[Imran Azam]

Hi

hope everyone is well.

I have a if formula which i am assuming gets the start date from the given data , but i do not quite understand the logic and how it is doing the, the formula is below

="01"&"/"&IF(MONTH(A2)<10,"0"&MONTH(A2),MONTH(A2))&"/"&YEAR(A2)

A2=29/11/2015

the formula returns 01/11/2015

can someone explain what is this exactly doing?

Thank you

 

[steve the fish]

Its producing the 1st day of the month for the date it finds in A2 but it gets returned in text form. Think id use:

=EOMONTH(A2,-1)+1

or

=A2-DAY(A2)+1