I Thought I knew this one but cant remember formula.I want to restrict a user entry of a date to be not greater than "NOW".IE:if today is the 13th September do not allow user to enter 14th September.
MANY THANKS
I Thought I knew this one but cant remember formula.I want to restrict a user entry of a date to be not greater than "NOW".IE:if today is the 13th September do not allow user to enter 14th September.
MANY THANKS
Assuming the DV is in cell C5
=C5<=TODAY()
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
BUT ... 10 would be valid in this case, so it depends on your users and if they can reformat the cell.
-10 would also be valid
It's not a perfect solution but I think Bob's is the best there is.
2+2=9 ... (My Arithmetic Is Mental)
Posting Permissions
Reply With Quote
