mysterious bug w/ date formula that is not working

[shivom400]

I am trying to recall the end of the month based off a day in a month, however the same formula (and format) is only working in some rows and not in others.  Looking for an expert that can help take a look and rectify.  Thank you

[#2]

@shivom400 Please show the formula and the context in which you show it.

[#3]

=IFERROR(EOMONTH(DATE(YEAR(K10),DAY(K10),MONTH(K10)),0),"--")

for this formula the value in k10 is 01/03/2022, where the format is DD/MM/YYYY

[#4]

I'm also using Month() to get the month of 04/03/2022 but it is showing month as 4 despite the date being formatted as DD/MM/2022 and so it should be showing 3

[#5]

@shivom400 You should be able to use:

=EOMONTH(K10,0)

provided that the value in K10 is a real date.

On your other issue, it seems that your system is set up to work with the mm/dd/yyyy format. Merely changing the display format doesn't change the second element to the month. In other words, a US style date 04/03/2022 = April 3, 2022. You may format it European style to display 03/04/2022, but it will still be 3 April 2022. Hence, the MONTH = 4.