Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how can you know the number of days of a certain month? 1
- Thread starter AxeaXeaxE
- Start date
It's a bit of a workaround but you can use teh EOMonth function - EOMonth gives the serial number of the last day in the same month (providing arg 2 = 0)
EOMonth("01/01/01",0) retuens the serial number for 31/01/01
therefore =(EOMonth(serialnumberfor1stofmonth,0)-serialnumberfor1stofmonth)+1 ('cos you're starting on day 1)
will give the number of days in a month
HTH
Geoff
EOMonth("01/01/01",0) retuens the serial number for 31/01/01
therefore =(EOMonth(serialnumberfor1stofmonth,0)-serialnumberfor1stofmonth)+1 ('cos you're starting on day 1)
will give the number of days in a month
HTH
Geoff
- Thread starter
- #3
-
1
- #4
SkipVought
Programmer
Hi,
Try this...
Skip,
metzgsk@voughtaircraft.com
Try this...
Code:
=DAY(EOMONTH(J6,0))Skip,
metzgsk@voughtaircraft.com
- Status
Similar threads
- Locked
- Helpful tip
- Locked
- Question
- Locked
- Question
