You are awesome!! I'm sorry for my use of caps, i pretty much leave them on
for all my spreadsheets, and didn't stop to differentiate between the
documents. But, thank you very much for your assistance!

Val

"Rick Rothstein" wrote:

For future postings, please turn off your Caps Lock key... text in all caps
is considered shouting and is VERY hard to read.

As for your questions, try this formula...

=IF(D3="","",IF(A$1-D35,"LATE","ON TIME"))

Notice for your first question, I prefixed the row number with a $ sign...
that makes that part of the reference absolute, that is non-changing when
copy/pasted... without the $ sign, the reference is relative and, as you
found out, changes when copy/pasted. I handled your second question by
nesting the IF function.

--
Rick (MVP - Excel)


"FRUSTRATED!!!" wrote in message
...
I WOULD ALSO LIKE THE CELL TO BE BLANK IF THERE IS NO VALUE ENTERED IN
COLUMN
D. :)

"FRUSTRATED!!!" wrote:

I AM CREATING A TRACKING LOG. THE FUNCTION I AM USING IS
=IF(A1-D35,"LATE","ON TIME") . A1 IS THE "NOW" FORMULA AND IS MY FIXED
POINT. I WANT IT TO READ THAT IF THE DATE ENTERED IN A SEPARATE COLUMN
IS
GREATER THAN 5 DAYS IT IS LATE. HOW CAN I FOMAT AN ENTIRE COLUMN WITHOUT
GOING BLOCK BY BLOCK? WHEN I COPY AND PASTE, I HAVE TO CONSISTENTLY
CHANGE
IT TO READ A1, BECAUSE IT WILL REVERT TO WHATEVER LINE I AM ON (A2, A34,
ETC.). i JUST WANT IT TO READ A1. AND IF I CAN GET THE "ON TIME" OR
"LATE"
TO POP UP IN GREEN OR RED, THAT WOULD BE AWESOME!!!