Forum Discussion
EOMonth Calclulation
Hello All,
I want to use EOMONTH calculation on a date where in my date format is 25.08.2018.
When I apply the formula am not getting the date. If I change the date format to 8/25/2018 then I get the value. But I have 6 lakh line items where date format is 25.08.2018.
Need help.
Hi,
A format like this 25.08.2018 isn't a valid date format this is why the EOMONTH function doesn't work!
To convert the dates to proper date format, please follow these steps:
- Select the dates
- Go to Data >> Data Tools >> Text to Columns
- In the Text to Columns dialog box, press Next twice to reach out to step 3 of 3
- In step 3 of 3, select Date, and select DMY format as shown in the below screenshot
- Click Finish
try this =EOMONTH(SUBSTITUTE(D4,".","/"),1)
Hi,
A format like this 25.08.2018 isn't a valid date format this is why the EOMONTH function doesn't work!
To convert the dates to proper date format, please follow these steps:
- Select the dates
- Go to Data >> Data Tools >> Text to Columns
- In the Text to Columns dialog box, press Next twice to reach out to step 3 of 3
- In step 3 of 3, select Date, and select DMY format as shown in the below screenshot
- Click Finish
