Forum Discussion

UserExcel 

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)

1 Reply

  • UserExcel's avatar
    UserExcel
    Copper Contributor
    Thanks it worked.... both ways are ok for me

Resources