I figured it out. thanks to anyone who's already replied!

"tjb" wrote:

When a user enters a date in A1, I want A2 to give me the last day of the
month from A1. Any ideas?