Help required on working with date

[Shanks]

Hi

I have dates in a column in dd-mmm-yy format, like

29-Mar-04
15-Apr-04
13-May-04

I want to put in the column adjecent to this date column
the date starting with 1st day of each month like -

01-Mar-04
01-Apr-04
01-May-04

How can this be done by use of formula?

I tried but do not get any clue to go futher.

-Shanks

 

[Frank Kabel]

Hi
try
=DATE(YEAR(A1),MONTH(A1),1)

 

[Alex Delamain]

If column A has your dates then column B should be
=eomonth(a1,-1)+1

This will calculate the last day of the previous month and then add 1
day.

 

[mzehr]

Hi,
use the following =EOMONTH("Date",-1)+1, where "date"
represents the cell address of the cells you want
evaluated. Note that you will need to have the analysis
toolpack addin installed to use this formula.

HTH.

 

[Shanks]

Tks Frank
It worked well !!

Shanks

-----Original Message-----
Hi
try
=DATE(YEAR(A1),MONTH(A1),1)

--
Regards
Frank Kabel
Frankfurt, Germany


.

 

[Ron Rosenfeld]

Hi

I have dates in a column in dd-mmm-yy format, like

29-Mar-04
15-Apr-04
13-May-04

I want to put in the column adjecent to this date column
the date starting with 1st day of each month like -

01-Mar-04
01-Apr-04
01-May-04

How can this be done by use of formula?

I tried but do not get any clue to go futher.

-Shanks

=A1+1-DAY(A1)

will give you the first day of the month of the date in A1


--ron