Prev: using excel cells to be inserted into Ms.Word fill-in fileds
Next: How to reverse column values in excel?
From: grizzly6969 on 14 May 2010 04:44
you are absolutely correct I didn't think of a leap year
--
grizz


"מיכאל (מיקי) אבידן" wrote:

> Usually, Excel is used for precise calculations - therefor I don't think the
> suggestion to reduce 1095 days (365*3) is a good idea because of some leap
> years with 366 days [such as 2008].
> Micky
>
>
> "grizzly6969" wrote:
>
> > say your date is in A15 ----conditional formal / formula is
> > =and(A15<today()-1095)
> > and format to your colour
> > --
> > grizz
> >
> >
> > "Teeny" wrote:
> >
> > > I have a column of dates and I want to highlight in red all dates that are
> > > equal to and more than 3 years old
> > >
> > > For example if the date is 02/10/04 this should be highlighted in red.
> > >
> > > I would appriciate anyones help!
From: Teeny on 14 May 2010 04:47
Thanks, this is similar to thow I have been doing it, however I need to
subtract full years and not 365 days as I realised this does not account for
leap years.

"RonaldoOneNil" wrote:

> Try setting the condition to
> Cell Value is
> Not Between
> =TODAY()
> =TODAY()-(365*3)
>
> "Teeny" wrote:
>
> > I have a column of dates and I want to highlight in red all dates that are
> > equal to and more than 3 years old
> >
> > For example if the date is 02/10/04 this should be highlighted in red.
> >
> > I would appriciate anyones help!
From: Jacob Skaria on 14 May 2010 04:49
Please check your other post.

--
Jacob (MVP - Excel)


"Teeny" wrote:

> I have a column of dates and I want to highlight in red all dates that are
> equal to and more than 3 years old
>
> For example if the date is 02/10/04 this should be highlighted in red.
>
> I would appriciate anyones help!
First  |  Prev  | 
Pages: 1 2
Prev: using excel cells to be inserted into Ms.Word fill-in fileds
Next: How to reverse column values in excel?