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" wrote in message
...

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

--

HTH

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


"timerigger" wrote in message
...

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" wrote in message
...

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" wrote in message
...

On Sat, 19 Mar 2005 07:51:04 -0800, "timerigger"
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: