First Day of the Month

J

Jen_T

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
 
O

Otávio Alves Ribeiro

Hi there.
Please, try:

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

Regards,
Otávio
 
R

Ron Rosenfeld

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
Click to expand...

=a1+1-day(a1)

--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

7 Day Pacing Formula Help 2
Transpose columns to rows using first columns repeated. 7
Countdiff with more criteria 20
counting the number of consecutive days 12-17-09 2
need a formula that has to do with dates. 1
Count if between date parameters 4
Generating date from day, month year 4
Counting cells with specific month in 7

Top