Help Please

[root2007]

Hi everyone,

Can you please help me on how to get the number of days per month? What is the VB syntax for it? Thanks and more power!

 

[sandy70]

u mean like Jan >> 31 days , Feb >> 29/28 days ??
if u mean like that u can use this
First Day of The month : DateSerial(Year(Now), Month(Now), 1)
Last Day of The Month : DateSerial(Year(Now), Month(Now) + 1, 0)
So number of the day : Last Day - First Day +1

 

[John Big Booty]

If you simply what to know how many days in the current month use;

=Format(DateSerial(Year(Date()),Month(Date())+1,0),"DD")

 

[John Big Booty]

as an aside, unless you specifically need a time component on your Update Value use Date() in preference to Now()

 

[John Big Booty]

You may also want to have a quick read of this prior to naming your next thread

 

[root2007]

Thank to for your help and thank you for the info you gave me about posting. More power!