Thread: 11 months and 1 day from a given date
View Single Post
  #2  
Old April 23rd, 2010, 01:52 AM posted to microsoft.public.excel.worksheet.functions
Tige Brown
external usenet poster
  
Posts: 7
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?