| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do i display the total number of days in the current month in.
|
|
#2
|
|||
|
|||
|
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 ... |
|
#3
|
|||
|
|||
|
=DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0))
-- HTH RP (remove nothere from the email address if mailing direct) "timerigger" wrote in message ... |
|
#4
|
|||
|
|||
|
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 ... |
|
#5
|
|||
|
|||
|
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 ... |
|
#6
|
|||
|
|||
|
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 |
|
#7
|
|||
|
|||
|
=day(eomonth(today(),0))
"timerigger" wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Where is DateDiff function in Excel 2002 ? | Excel Worksheet Functions | |||
| How do I display an insignificant 0 at the beginning of a number | Excel Discussion (Misc queries) | |||
| Count number of days in given month? | Excel Worksheet Functions | |||
| Calculating interest on number of days in the period | Excel Worksheet Functions | |||
| Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions | |||
Linear Mode
