90 days or less than please

[HNoel33]

I have this formula that will tell me if a date is greater than 90 days... if it is, it'll say YES...............
=IF(D4>=90,"","Yes")
Well how would i go about incorporating it to tell me No in the same formula?

Also -
I have dates i am pulling over from another sheet (90 days old) -but there are some cells that are pulling over 0 (zeros) because there is no date in the column i am pulling from.
How can i not see zeros and simply keep them blank?

[scott.s.fower]

=if(D4=0,"",if(D4<90,"NO",IF(D4>=90,"","Yes")))

[HNoel33]

greater than 90.xls

Great!! thank you!!!
but the yes and no part is seperate from the zeros part...

i am sorry that was my fault for noy explaining better.

Can you give me a formula that would pull over the dates that are greater than 90 days ONLY. And the cells that are blank (w/o dates) I DO NOT want pulling over zeros..... i would rather it just stay blank...

i have attached a sample for you above my intro line i hope this better explains it ...

[HNoel33]

1/0/00
i get the above date when i am pulling over dates 90 days greater.... and the cell is blank... itll pull oer 1/0/00