Thread: Date = first day of next month
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
  
Posts: 1,240
Default Date = first day of next month
Dylan @ UAFC wrote:
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


There are several options. Try this one:

=DATE(Year(A1),MONTH(A1)+1,1)
Reply With QuoteReply With Quote