ExcelBanter - Rounding Dates to the 1st?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Rounding Dates to the 1st? (https://www.excelbanter.com/excel-discussion-misc-queries/71446-rounding-dates-1st.html)

lawdoggy

Rounding Dates to the 1st?

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

Rounding Dates to the 1st?

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

€œ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

Ron Rosenfeld

Rounding Dates to the 1st?

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

Biff

Rounding Dates to the 1st?

Hi!

Try this:

A1 = date

=A1-DAY(A1)+1

Biff

"lawdoggy" wrote in message
oups.com...
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

All times are GMT +1. The time now is 09:15 AM.