Mar 14 2021 06:12 AM
I have only year and month and i need the date column as it is :-Thanks community
Mar 14 2021 06:18 AM
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)
Mar 14 2021 06:31 AM
Duplication of latest question i Re: Problem with date - Microsoft Tech Community