I ve selected some dates via a simple if statement and can see the dates in the cell where I want them. But when I try to use them in another formula it doesn't recognise them as dates regardless of how I try to format them. Can anyone help?
I get the date from one of two columns of dates with:
then try to use them with: