You can simplify this if it is for conditional formatting. Just use this
portion of it in a "formula is" format.

=AND(ISNUMBER($E18),$E18<(TODAY()+30))

Set that condition as your first, then add a second condition of:

=AND(ISNUMBER($E18),$E18<(TODAY()+60))


The first condition will apply if the date is within 30 days, and the 2d
will apply when within 60 days. Even though the days overlap, the first
condition takes precedence.



"Jules" wrote:

I have a spreadsheet which has expiration dates in Column B I am using this
formula in coditional formating to have it highlight the row when its 30
days from expiration.

=IF(AND(ISNUMBER($E18),$E18<(TODAY()+30)),TRUE,FAL SE)

I need it be be from 0-30 days and I need one for 31-60 days...can anyone
tell me how to do this...or tell me if there is a better way? Also, how can
I protect the formula but allow folks to do the data entry?

thanks, I am trudging the road to happier spradsheets!
-- Jules