Jun 03 2022 01:45 AM
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
Jun 03 2022 01:47 AM
@shivom400 Please show the formula and the context in which you show it.
Jun 03 2022 01:50 AM
Jun 03 2022 01:51 AM
Jun 03 2022 02:25 AM
@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.