=EOMONTH(DATEVALUE("2011-01-01"),3)

JIN GYU Bak 0 Reputation points
2026-06-14T11:12:15.2566667+00:00

4344년 4월 30일4344년 4월 30일=EOMONTH(DATEVALUE("2011-01-01"),3)

위 함수 결과가 위의 수치처럼 4천년대로 표기되는데 수정방법없나요? 웹엑셀입니다.

above function shows the result(4344y) that is typed at the top of this page.

Is there any fixs that I can apply to?

Microsoft 365 and Office | Excel | Other | Other
0 comments No comments

1 answer

Sort by: Oldest
  1. AI answer

    2026-06-14T11:12:24.39+00:00

    The function itself is correct. The issue is that the text date is being interpreted with a different date system/locale, so DATEVALUE("2011-01-01") is not being converted to the intended 2011-01-01 serial date, which then makes EOMONTH return a completely different (far future) date.

    To fix it in Web Excel:

    1. Enter the start date as a real date value in a cell, not as a text literal inside DATEVALUE.
      • For example, type 2011-01-01 into cell A1 and ensure it is right‑aligned (recognized as a date).
    2. Use EOMONTH directly on that cell:
         =EOMONTH(A1,3)
      
    3. If the locale expects a different date format, type the date in that format (for example 2011/01/01 or 01/01/2011) so that Excel recognizes it as a date.
    4. If dates are stored as text and not recognized, convert them to real dates first (for example, using Text to Columns or a DATE formula) and then apply EOMONTH.

    Once the start date is a valid Excel date value in the correct system, =EOMONTH(start_date,3) will return 2011‑04‑30 instead of a year in the 4000s.


    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.