View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Date = first day of next month

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


--
__________________________________
HTH

Bob

"Dylan @ UAFC" wrote in message
...
in
A B
1/19/2088 2/1/2008
2/20/2008 3/1/2008
1/23/2008 2/1/2008
What formula can I use in the B column to make this
happen