ExcelBanter - First Day of the Month

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - First Day of the Month (https://www.excelbanter.com/excel-worksheet-functions/250960-first-day-month.html)

Jen_T

First Day of the Month

Is there a function or a way that I can look at a cell (A2) in date format
and pull in the first day of the month in B2.
Example:
A B
12/25/2009 12/1/2009
5/19/2009 5/1/2009

Otávio Alves Ribeiro

First Day of the Month

Hi there.
Please, try:

=DATE(YEAR(A2),MONTH(A2),1)

Regards,
Otávio

"Jen_T" wrote:

Is there a function or a way that I can look at a cell (A2) in date format
and pull in the first day of the month in B2.
Example:
A B
12/25/2009 12/1/2009
5/19/2009 5/1/2009

Ron Rosenfeld

First Day of the Month

On Mon, 14 Dec 2009 05:21:02 -0800, Jen_T
wrote:

Is there a function or a way that I can look at a cell (A2) in date format
and pull in the first day of the month in B2.
Example:
A B
12/25/2009 12/1/2009
5/19/2009 5/1/2009

=a1+1-day(a1)

--ron

All times are GMT +1. The time now is 11:32 PM.