Thread: Date Projection
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TomPl TomPl is offline
external usenet poster
  
Posts: 342
Default Date Projection
=DATE(YEAR(A5),MONTH(A5)+1,DAY(1))
Reply With QuoteReply With Quote