Forum Discussion

Chandrakanth K's avatar
Chandrakanth K
Copper Contributor
Aug 30, 2018
Solved

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 ge...
excel
Formulas and Functions
  • Haytham Amairah's avatar
    Haytham Amairah
    Aug 30, 2018

    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

Philip West's avatar
Philip West
Steel Contributor
Aug 30, 2018

try this =EOMONTH(SUBSTITUTE(D4,".","/"),1)