First day of the Month

[Soniya]

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

 

[Dave]

Try

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

Cheers

Dave

 

[Chip Pearson]

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 (e-mail address removed)

 

[Bob Phillips]

Soniya,

Try

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