LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Purple_Jack
 
Posts: n/a
Default End of Month question


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. :)


--
Purple_Jack
------------------------------------------------------------------------
Purple_Jack's Profile: http://www.excelforum.com/member.php...o&userid=23884
View this thread: http://www.excelforum.com/showthread...hreadid=375192

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Month and Days question Anthony Slater Excel Discussion (Misc queries) 2 February 22nd 05 12:29 PM
Add one month to the previuos month heater Excel Discussion (Misc queries) 5 February 10th 05 12:33 AM
Month Year Date Format Jamie Excel Worksheet Functions 2 February 7th 05 06:43 PM
Accounting Month vs. Calendar Month JN Excel Worksheet Functions 4 January 31st 05 08:09 PM
Schedule Rotation Question Bob Excel Worksheet Functions 4 November 24th 04 06:54 AM


All times are GMT +1. The time now is 10:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"