In excel from which tab you can write date of birth like this YYYY/MM/DD.

A ) Input

B ) Format menu ✅

C ) Insert

D ) Cell


Explanation: In the Format Cells box, click the Number tab. In the Category list, click Date, and then choose a date format you want in Type. You can adjust this format in the last step below. Go back to the Category list, and choose Custom.