First day of the Month
 

Hi All,

How can I get first day of the selected month (from given
date)

eg. if I enter 21/8/2003 in A1 i want to get 1/8/2003 in
B1

TIA

Soniya

First day of the Month
 

Try

B1 =DATE(YEAR(A1),MONTH(A1),1)

Cheers

Dave



"Soniya" wrote in message
...

Hi All,

How can I get first day of the selected month (from given
date)

eg. if I enter 21/8/2003 in A1 i want to get 1/8/2003 in
B1

TIA

Soniya

First day of the Month
 

Soniya,

You can do this with a formula

=DATE(YEAR(A1),MONTH(A1),1)
or
=A1-DAY(A1)+1


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Soniya" wrote in message
...

Hi All,

How can I get first day of the selected month (from given
date)

eg. if I enter 21/8/2003 in A1 i want to get 1/8/2003 in
B1

TIA

Soniya

First day of the Month
 

Soniya,

Try

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

--

HTH

Bob Phillips

"Soniya" wrote in message
...

Hi All,

How can I get first day of the selected month (from given
date)

eg. if I enter 21/8/2003 in A1 i want to get 1/8/2003 in
B1

TIA

Soniya