Thread: Advancing date to the first of next month?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Statesman Statesman is offline
external usenet poster
  
Posts: 7
Default Advancing date to the first of next month?
I have a "start date" of 12/17/06 & I need a formula that will advance first
billing date to 01/10/05. I'm already using "=date(year(a1),month(a1)+1,10)".
When going from December to January, I'm getting #NUM! Thanks!!
Reply With QuoteReply With Quote