how do i display the total number of days in the current month in.

hi

please repost with a brief description in the subject line and the complete
question in the message body as the subject line is truncated.

Cheers
JulieD

"timerigger" <[email protected]> wrote in message
news:[email protected]...
>

=DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"timerigger" <[email protected]> wrote in message
news:[email protected]...
>

oops..my first post.

How do I display the number of days in the current month?

"JulieD" wrote:

> hi
>
> please repost with a brief description in the subject line and the complete
> question in the message body as the subject line is truncated.
>
> Cheers
> JulieD
>
> "timerigger" <[email protected]> wrote in message
> news:[email protected]...
> >
>
>
>

Excellent..Thanks!!

"Bob Phillips" wrote:

> =DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0))
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "timerigger" <[email protected]> wrote in message
> news:[email protected]...
> >
>
>
>

On Sat, 19 Mar 2005 07:51:04 -0800, "timerigger"
<[email protected]> wrote:

>oops..my first post.
>
>How do I display the number of days in the current month?
>

=32-DAY(TODAY()-DAY(TODAY())+32)


--ron

=day(eomonth(today(),0))

"timerigger" wrote:

>