Forum Discussion
Date
I have only year and month and i need the date column as it is :-Thanks community
Do you want the 3rd day of the month?
=DATE(A2,B2,3)
Or do you want the 1st day of January, 2nd day of February, 3rd day of March etc.?
=DATE(A2,B2,B2)
Thanks it worked.... both ways are ok for me