Formula to calc number of days in a given month

[FrostByte]

Im trying do do what I think should be simple i.e. calculate the number of days in a given month but I cannot work it out.

Any help you be appreciated.

 

[gemma-the-husky]

the easiest way is to set a date equal to the first of the following month, and subtract one. That gives you the last day of the previous month, and then you can use the DAY() function.
Alternatively, have an array set to {31,28,31,30 etc), although you still get the issue with the leap day that way.

 

[Uncle Gizmo]

This thread covers a few different ways:-

VBA Formula for: Last Day of Last Month

Hi! I'm used to Excel, and trying to convert some things I've done there to Access. (Without using a Reference to the Excel Object Library in my Access Project) I'm looking for the VBA equivalent of this Excel formula: =EOMONTH(TODAY(),-1) Which gives me the SerialDate # of the last day of...

www.access-programmers.co.uk

 

[Gasman]

I seem to recall @Pat Hartman uploaded a db with handy date routines? Search for it here.

 

[Uncle Gizmo]

I seem to recall @Pat Hartman uploaded a db with handy date routines?

Do you mean this one Paul?

Post in thread 'Adding business days and holidays to a date.' https://www.access-programmers.co.u...ys-and-holidays-to-a-date.287036/post-1749616

 

[Gasman]

Do you mean this one Paul?

Post in thread 'Adding business days and holidays to a date.' https://www.access-programmers.co.u...ys-and-holidays-to-a-date.287036/post-1749616

Yes, more than likely. She has posted it several times I seem to recall. I was on my phone for that message, was waiting until I got back home on a PC to search easier.
Thanks Tony.

 

[theDBguy]

How about?

Day(DateSerial(Year(DateField), Month(DateField)+1, 0))

You didn't say how you're going to supply the month to search, so I just assumed you will use a date value.
Hope that helps...