Merry

Robert,

Oops, sorry, your calendar is correct, but your date format
needs a slight
modification to work for Yanks.  This works for m/d/y
format:

=DAY(DATEVALUE(MONTH(ROW($2:$13)*30)&"/1/2006"
)-1)

Sweet!

Douglas M. Smith
www.abundant-solutions.com


--- Robert McCurdy <robertwmORCON.NET.NZ> wrote:

> Thanks Doug, those spreadsheets weight a ton ;)
> 
> Hey, I came up with this a few days ago;  It returns an
array of the last day
> number, for each month for that year.
> 
>
=DAY(DATEVALUE("1/"&MONTH(ROW($2:$13)*30)&
"/2006")-1)
> 
> Just select the formula and F9 it to see the array.
> 
> 
> Regards
> Robert McCurdy
> ----- Original Message ----- 
> From: "Douglas Smith" <dougABUNDANT-SOLUTIONS.COM>
> To: <EXCEL-GPEACH.EASE.LSOFT.COM>
> Sent: Tuesday, December 26, 2006 10:31 AM
> Subject: Re: Merry
> 
> 
> Same to you David.  The board has been dead quiet.  I
guess it is possible
> for
> us to put down our spreadsheets for a while.  
> 
> Doug Smith
> www.abundant-solutions.com
> 
> 
> --- "David G. Miley" <dgmileyFLASH.NET> wrote:
> 
> > Christmas to all.
> > 
> >
------------------------------------------------------------
--------------
> > The EXCEL-G list is hosted on a Windows NT(TM)
machine running L-Soft
> > international's LISTSERV(R) software.  For
subscription/signoff info
> > and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
> >                              COPYRIGHT INFO:
> > http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
> > 
> 
>
------------------------------------------------------------
--------------
> The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
> international's LISTSERV(R) software.  For
subscription/signoff info
> and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
>                              COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
> 
>
------------------------------------------------------------
--------------
> The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
> international's LISTSERV(R) software.  For
subscription/signoff info
> and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
>                              COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
> 

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G