Trying to get a whole date excel

I have 3 seperate dates
cell C2 = 1/03/2017 it is a data validation cell and if formatted to custom mmmm ;@ custom
Cell C3 = 01/01/2017 it is a data validation cell and if formatted to custom yyyy ;@ custom
My day number in B4 is =$F$2+(0-WEEKDAY($F$2)) which is formatted to ddd custom
and underneath in B5 is =B$4 formatted to dd custom
B4 and B5 are calendar dates and go across the columns with C4 = B4+1 and C5 = C4

I am trying to get a whole date as in dd/mm/yyyy
so the day from B5 and the month from C2 and the year from C3

You don't say what is in cell F2, but you can use this:

=DATE(YEAR(C3),MONTH(C2),DAY(B5))

and format as appropriate.

Hope this helps.

Pete

That was brilliant!!
so how do I put that so it fills a text box on my userform the day will be the active cell and form will open when left click on day making it the active cell in vba