Prev: Excel 2003 - importing info from closed workbooks
Next: Find
From: Bruce D. on 27 May 2010 16:09
I am using excel 2007 and I have 4 columns; acct no, bill amt, enter date,
eff date.
I want to flag the records somehow if the "eff date" is with 90 days of the
"enter date". Is there some type of formula or IF statement I could use?

Thanks!
--
Bruce
From: Dave Peterson on 27 May 2010 16:28
I would add another column that returns true/false:
=abs(c2-d2)<=90

Then I could apply data|filter|autofilter to see the True's or false's.

Since I used =abs(), I didn't care if it was 90 days before or 90 days after.
You may want to change that formula to what you really want.

Bruce D. wrote:
>
> I am using excel 2007 and I have 4 columns; acct no, bill amt, enter date,
> eff date.
> I want to flag the records somehow if the "eff date" is with 90 days of the
> "enter date". Is there some type of formula or IF statement I could use?
>
> Thanks!
> --
> Bruce

--

Dave Peterson
From: Jeff on 27 May 2010 16:53
Bruce - In the next column, use
=if(eff_date-enter_date<=90,"on time","late")
Alternatively, you could use conditional formatting to highlight or
otherwise identify records meeting your specification.

"Bruce D." wrote:

> I am using excel 2007 and I have 4 columns; acct no, bill amt, enter date,
> eff date.
> I want to flag the records somehow if the "eff date" is with 90 days of the
> "enter date". Is there some type of formula or IF statement I could use?
>
> Thanks!
> --
> Bruce
 | 
Pages: 1
Prev: Excel 2003 - importing info from closed workbooks
Next: Find