Preacherman771
New Member
- Joined
- Jun 15, 2021
- Messages
- 46
- Office Version
- 365
- Platform
- Windows
Needing to find the last day of a given month I found the formula EOMONTH(start-date,month(s)). When I enter EOMONTH(A2,0) (A2="1/1/2022") or EOMONTH("1-Jan-2022",0) the return value is Jan-22. Regardless of which #months I use it returns the correct month but the 22th, "Month-22". I checked the cells formatting which is "Date". Would appreciate any help.