Thread: First day of the Month
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave[_15_] Dave[_15_] is offline
external usenet poster
  
Posts: 11
Default 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


Reply With QuoteReply With Quote