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.

Help needed with If & Today function
 

Nemo wrote:
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.


First, rows are numbered, columns have letters. Getting that right would make
your question more clear.

Look at Data Validation. Assuming you want this behavior in rows 3 through 10,
select C3:AG10 and select Data / Validation. On the Settings tab, for Allow
select Custom and for Formula enter the following:

=C2=TODAY()

Fill in the Input Message and Error Alert tabs as desired and click OK.

Help needed with If & Today function
 

Glenn wrote:
Nemo wrote:
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.


First, rows are numbered, columns have letters. Getting that right
would make your question more clear.

Look at Data Validation. Assuming you want this behavior in rows 3
through 10, select C3:AG10 and select Data / Validation. On the
Settings tab, for Allow select Custom and for Formula enter the following:

=C2=TODAY()

Fill in the Input Message and Error Alert tabs as desired and click OK.

Sorry, should be this:

=C$2=TODAY()

Help needed with If & Today function
 

It worked, Thanks a ton !!!!

"Glenn" wrote:

Glenn wrote:
Nemo wrote:
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.


First, rows are numbered, columns have letters. Getting that right
would make your question more clear.

Look at Data Validation. Assuming you want this behavior in rows 3
through 10, select C3:AG10 and select Data / Validation. On the
Settings tab, for Allow select Custom and for Formula enter the following:

=C2=TODAY()

Fill in the Input Message and Error Alert tabs as desired and click OK.

Sorry, should be this:

=C$2=TODAY()
.

Help needed with If & Today function
 

You're welcome!

Nemo wrote:
It worked, Thanks a ton !!!!

"Glenn" wrote:

Glenn wrote:
Nemo wrote:
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.

First, rows are numbered, columns have letters. Getting that right
would make your question more clear.

Look at Data Validation. Assuming you want this behavior in rows 3
through 10, select C3:AG10 and select Data / Validation. On the
Settings tab, for Allow select Custom and for Formula enter the following:

=C2=TODAY()

Fill in the Input Message and Error Alert tabs as desired and click OK.
Sorry, should be this:

=C$2=TODAY()
.