From: puiuluipui on 16 Mar 2010 07:03 Hi, works great. Thanks1 But how to add to a date exactly 5 years? Thanks! "Jacob Skaria" wrote: > A1 = 161 > Try formula > > =DATE(2008,1,A1) > > -- > Jacob > > > "puiuluipui" wrote: > > > Hi, i need to know what day and month is the below date. > > > > 161th day of 2008 > > i have many days like this. i need a formula or something. > > > > I need them in dd/mm/yyy format. > > Can this be done? > > Thanks! From: Jacob Skaria on 16 Mar 2010 07:08 Try =DATE(YEAR(A1)+5,MONTH(A1),DAY(A1)) -- Jacob "puiuluipui" wrote: > Hi, works great. > Thanks1 > > But how to add to a date exactly 5 years? > > Thanks! > > > > > "Jacob Skaria" wrote: > > > A1 = 161 > > Try formula > > > > =DATE(2008,1,A1) > > > > -- > > Jacob > > > > > > "puiuluipui" wrote: > > > > > Hi, i need to know what day and month is the below date. > > > > > > 161th day of 2008 > > > i have many days like this. i need a formula or something. > > > > > > I need them in dd/mm/yyy format. > > > Can this be done? > > > Thanks! From: puiuluipui on 16 Mar 2010 07:15 Perfect! Thanks! "Jacob Skaria" wrote: > Try > =DATE(YEAR(A1)+5,MONTH(A1),DAY(A1)) > > -- > Jacob > > > "puiuluipui" wrote: > > > Hi, works great. > > Thanks1 > > > > But how to add to a date exactly 5 years? > > > > Thanks! > > > > > > > > > > "Jacob Skaria" wrote: > > > > > A1 = 161 > > > Try formula > > > > > > =DATE(2008,1,A1) > > > > > > -- > > > Jacob > > > > > > > > > "puiuluipui" wrote: > > > > > > > Hi, i need to know what day and month is the below date. > > > > > > > > 161th day of 2008 > > > > i have many days like this. i need a formula or something. > > > > > > > > I need them in dd/mm/yyy format. > > > > Can this be done? > > > > Thanks! First  |  Prev  |  Pages: 1 2 Prev: Custom Sort order issueNext: reduce excel file size