View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nemo Nemo is offline
external usenet poster
 
Posts: 10
Default Help needed with If & Today function

I have a row where I have dates of the month - C2:AG2. I want a formula,
where if I enter a text in the corresponding row, and if the date is not
todays date, it shud not allow me to enter text.
Cl 1 Cl 2 Cl 3 Cl 4 Cl 14 Cl 15
Cl 16
Eg: Row A - 1 apr 2 apr 3 apr 4 apr ..... 14 apr 15 apr 16 apr
Row B - P

Now if I try to enter a value in row B, it shud not allow as the date is not
today date. I shud be able to enter value only if the date corresponds to
todays date.

Is this possible, Pls help !!!!! Hope I've made my question clear.