Date result
Instead of writing one formula u can write multiple formula and then concatenate it, so that the date won't get converted into number. The formula in COLOUMN F needs to be written first in accordance with the number mention and afterwards the main formula than u needed. Go through the sample attachment for reference.
|