calculate first or last day of a month

[JustATheory]

Greetings,

I have a date column and I'd like to calculate in the next column the last date of the month and from that column the number of days that represents. I'm good with calculating the number of days, but is there a function that will look at a date and give the last date of that month?

Thanks,
Andy

 

[SkipVought]

Hi,

LastDay: DateSerial(Year([YourDate]),Month([YourDate])+1,0)

Skip,

_{[red]Be Advised![/red] The only distinction between a bird with one wing and a bird with two, is merely...
a difference of A Pinion!}

 

[Golom]

DaysToEndOFMonth =
DateDiff ("d", [DateField], 
DateSerial(Year([DateField), Month([DateField]) + 1, 0))