Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
=TODAY() and HLOOKUP - help needed | Excel Discussion (Misc queries) | |||
=TODAY() and HLOOKUP - help needed | Excel Discussion (Misc queries) | |||
Do I use the TODAY() FUNCTION | New Users to Excel | |||
I'm using the =today() function but I'm getting ##### | Excel Worksheet Functions | |||
Today() & Now() function | Excel Worksheet Functions |