Sorry, silly question, I was sure they knew about it, just really wondering
if they are ever going to fix it...
--
** John C **

"Peo Sjoblom" wrote:

Yes, they copied this intentionally from Lotus 123 where it was a bug.
Of course that was before they became a de facto monopoly and when Lotus 123
was the leading spreadsheet.

--


Regards,


Peo Sjoblom

"John C" <johnc@stateofdenial wrote in message
...
Just curious, is that an error that MS is aware of? 1900 is not a leap
year :)
--
** John C **


"T. Valko" wrote:

=EOMONTH(A1,0)+1

The Op will probably be ok if they use that but try it on this date:

2/11/1900

--
Biff
Microsoft Excel MVP


"Spiky" wrote in message
...
On Oct 31, 1:16 pm, Paul wrote:
I have 2 columns. In the first column I would have dates and I want the
next
column to project teh first day of the upcoming month based on the date
in
column A. Anyway way to do that as a function?

Thank you in advance for any assistance.

With Excel 2007 or Analysis Toolpak:

=EOMONTH(A1,0)+1