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