Thanks guys! Got it figured out and learned a lot!

2. Here is another question for you guys. I have the formula =(DATE(YEAR(E5), MONTH(E5), DAY(E5)+20) but I want to add to it an IF statement. I would like to say that if E5 is blank that I can have the phrase "enter date" in that field. I tried using =IF(E5>0,"Enter Date","Enter Date") but it didnt work. What am I doing wrong? Thanks again!

3. =IF(E5="","Enter date",E5+20)
should do it.

4. Unfortunately no, it didnt work.

5. In what way?

6. I think what he wants is:

=IF(ISNUMBER(E5),DATE(YEAR(E5), MONTH(E5), DAY(E5)+20,"Enter a date")

It doesn't actually check if it's a date but is functionally the same as checking the value vs 0.

Jesse

7. Is 0 not a number?
All that Date stuff is still unnecessary - just add 20.

8. vs GREATER than zero :P

Good call on the date, I totally skipped over that. You're totally right, just ignore the last thing I said. Must have had some bad coffee........

Jesse

Page 2 of 2 First 1 2

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•