Prev: Custom Sort order issue
Next: reduce excel file size
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 issue
Next: reduce excel file size