Ronderbecke
Board Regular
- Joined
- Oct 4, 2017
- Messages
- 73
I have embedded into a formula a simple function for using sumproduct and in the middle of the function is this:
=Date(2022,12,1)
It works fine like that but when I have 2022,12,1 in cell E4 I can't just use =DATE(E4) and have tried using text function and indirect function and nothing is working. I know this is probably something stupid I am missing but how do you change out what I have in date and use data from a cell that looks literally the exact same?
=Date(2022,12,1)
It works fine like that but when I have 2022,12,1 in cell E4 I can't just use =DATE(E4) and have tried using text function and indirect function and nothing is working. I know this is probably something stupid I am missing but how do you change out what I have in date and use data from a cell that looks literally the exact same?