I am not clear whether this is what you are looking for€¦

A1 Date is greater than or equal to B1and if you want to display the C1 cell
value then use this formula:
Use this formula other than A1,B1 & C1 cell
=IF(A1=B1,C1,"")

If you want to use the date value in the formula itself then use the below,
It will check whether the A1 Date Value is greater than or equal to the
mentioned date value and return the C1 value.
=IF(A1=DATE(2009,7,31),C1,"")

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"michaeldmaxey" wrote:

i am trying to have a criteria that one cell is greater than or equal to a
date but i want the date to reference another cell. For instance =B3
(greater than or equal to the date located in cell B3). The criteria works
if i write =7/31/09 but i want the date to refer to another cell where i can
change that date one time.