On 13 Feb 2006 18:38:36 -0800, "lawdoggy" wrote:

Hello,

How do I round any date to the first of that month?

Example: Jan 25 == Jan 01
Dec 14 == Dec 01

Any Help is appreciated. thanks.........mitch

=a1+1-day(a1)


--ron