End of Month question

  • Thread starter Thread starter Purple_Jack
  • Start date Start date
P

Purple_Jack

In a cell, I have the current date in format -dd/mm/yyyy-. In the cell
below, I want to automatically insert the text Yes if this is the last
day of the month or No if it isn't.

What's the simplest way to do this?

Thanks in advance. :)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting MM/DD/YYYY into just MM/DD and Sorting 1
Converting date format 4
Date and Number cell formats 4
Excel Vba to change displayed year automatically. 14
Change format to mm dd yyyy hh mm ss 1
Excel Excel 'end of month' datedif and Conditional formatting 1
format cells from mm/dd/yyyy to yyyy 3
Excel Monthly Spread sheet. 12

Back
Top