Thread: 11 months and 1 day from a given date
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default 11 months and 1 day from a given date
In the future?

With the date in A1:

=date(year(a1),month(a1)+11,day(a1)+1)



pk wrote:

How can I calculate 11 months and 1 day from a given date using an excel 2003
function?

--

Dave Peterson
Reply With QuoteReply With Quote