If you find a data with date column in which date has been stored as shown below
05.06.2010 it is read as June 05, 2010, but it can also be read as May 06, 2010. The correct one is June 05, 2010 according to my regional settings.
If you replace the full stop sign with slash sign,it is possible that the date is converted to May 06,2010 which is incorrect answer.
In this scenario you can use DATE Function along with LEFT, RIGHT and MID Function to solve the problem.
Read more DATE Function
You can get total number of days of each month by using DAY function and EOMONTH Function
Read more Get total number of days of each month
The day function is used to find day from a date,for example, the Day Function return 20 from 20/Jan/2020
Read more DAY Function
Returns the serial number for the last day of the month that is the indicated number of months before or after start_date. Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.
Read more EOMONTH Function
Sometimes we need start date and end date of a month for our financial model. We can solve this problem by using EOMONTH Function.
Read more How to Get Start Date end Date of a Month Form a Date