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