Check col of dates.....each date is the first of the month

[welchs101]

Hi,

I have a column of dates and i want a way of checking that each value in the column represents the first day of a given month........there are multiple months in the file i just want a way to verify that each day represents the first day of a month.......any ideas?

fyi: need it in vba

[TMS]

One way:

=IF(A1=DATE(YEAR(A1),MONTH(A1),1),"first","not first")

and copy down

or, maybe simpler:

=IF(DAY(A1)=1,"first","not first")

Regards

[Domski]

Maybe something like this:

Please Login or Register  to view this content.

Dom

[welchs101]

thanks guys!

[TMS]

You're welcome. Thanks for the rep.

Regards