First Day of the month

J

Jen_T

Does anyone know how to have excel look at a cell that has a date that is
formatted as xx/xx/xxxx (E.g. Cell A2 = 01/16/2007) and show the date as
01/01/2007 in B2, another words view as date as first day of the month.
 
R

Ron Rosenfeld

Does anyone know how to have excel look at a cell that has a date that is
formatted as xx/xx/xxxx (E.g. Cell A2 = 01/16/2007) and show the date as
01/01/2007 in B2, another words view as date as first day of the month.
Click to expand...

B2: =A2-DAY(A2)+1
--ron
 
A

Ashish Mathur

Hi,

You may also try this

=EOMONTH(F7,-1)+1

You may need to install the analysis Toolpak for the eomonth function to
work
 

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

VBA - exporting serial letters to single documents 0
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Extract Month and year from Cell containing date, month, year & time 2
Date lists 3
separating date and time 5
Percentage of month passed formula 1
First Day of the Month 2
Generating date from day, month year 4

Top