Date

I have only year and month and i need the date column as it is :-Thanks community

3 Replies

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)

Duplication of latest question i Re: Problem with date - Microsoft Tech Community

Thanks it worked.... both ways are ok for me