Rounding Dates to the 1st?

[lawdoggy]

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

 

[wdjsxj]

=date(year(a1),month(a1),1)

“lawdoggyâ€ç¼–写：

 

[Ron Rosenfeld]

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

 

[Biff]

Hi!

Try this:

A1 = date

=A1-DAY(A1)+1

Biff