LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
DavidC
 
Posts: n/a
Default End of month function

Hi,

Have found an interesting situation. I run Office 2000, and Excel has a
neat function called "eomonth". This allows a spreadsheet to be set up with
the start and end of month dates automatically filled in. My colleague has
2003, and lo and behold, the "eomonth" function has been removed. We found a
work arround courtesy of John Wallenbeck, but have to wonder and ask the
question, WHY does microsoft remove good functionality in later versions.
Aside from the apparent illogicality of the move, it will render any
spreadsheet using that or any other simillar function, useless when opened in
a later version.

Thye general rule is that there has been backward compatibility from one
version to the next, yet this is one clear example where the backward
compatability is missing.

Does anyone have any idea why a perfectly good and workable function should
be removed?

regards

DavidC
 
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
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
Function or formula to convert "text" month to number of month Steve Vincent Excel Discussion (Misc queries) 1 February 4th 06 04:19 PM
Is there a function that gives us the last day of a month Grd Excel Worksheet Functions 3 November 10th 05 03:31 PM
Automatically up date time in a cell Mark Excel Discussion (Misc queries) 5 May 12th 05 12:26 AM
clock Wildman Excel Worksheet Functions 2 April 26th 05 10:31 AM


All times are GMT +1. The time now is 04:11 AM.

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"