"Today ()"worksheet function help

  • Thread starter Thread starter Vayne
  • Start date Start date
V

Vayne

hello

i'm fairly new to excel and i'm trying to use the Today() function in
formula but i get an error....what i need to do is reference anothe
cell that has a date in it and only return a value if the reference
cell is less than today....the first part of the "and" statement i
there to check another date and return a value for each month of th
year after or on that other date

what i have is this

AND($D2>=DATE(2004,1,1),TODAY()<=$E2)

please help if you can.....thank
 
=IF(AND($D2>=DATE(2004,1,1),TODAY()<=$E2),value_if_true,"")

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Back
Top