Convert date of birth into Words in Microsoft Excel 2021 using only formula without VBA

In this video I will show you how to get date of birth into words in Microsoft Excel version 2021. Here I have used only excel's built-in function. No any VBA code is used.
So it will be a much useful for you.

I am going to type December 5th 2005.

The formula is a bit longer but it's pretty very simple as compared with VBA code.

All you have to do is to copy this entire formula and paste it in your work file.
Please note to replace the cell address. That's A2 in my file.
All you have to do is to copy and paste this formula.

I have given this formula in first comment.

I have given a downloadable link of this work file here. You can download it from there:
https://drive.google.com/uc?export=download&id=1O-7BbpX-OYbg7VsHLdPj6G4KH7BRhsK7

Видео Convert date of birth into Words in Microsoft Excel 2021 using only formula without VBA канала iCals Digital Solutions