Forum Discussion
Date
I have only year and month and i need the date column as it is :-Thanks community
3 Replies
Duplication of latest question i Re: Problem with date - Microsoft Tech 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
