If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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() |
#4
|
|||
|
|||
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() . |
#5
|
|||
|
|||
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() . |
Thread Tools | |
Display Modes | |
|
|