|What are you really asking for: the contents of cell Y to be based on digits or based on dates?|
For digits, you could something like the INDEX function:
With 1, 2 or 3 in A1, this would return the value in A2, B2, or C2 since the value in A1 would be used as the column_num argument:
If you are really looking to return a value from a column based on a date, you could use one of many different functions, including:
Where DAY(A1) would return the Day number of the date in A1 and use that as the column_num argument.
The more specific you are with your request, the more specific we can be with a suggestion.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.