Thread: 11 months and 1 day from a given date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tige Brown Tige Brown is offline
external usenet poster
  
Posts: 2
Default 11 months and 1 day from a given date
Presuming the date is in cell 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?
Reply With QuoteReply With Quote