Hi All,
I have two dates in two different columns for example a date in cell A1 and a date in cell B1.
I want to use dates from both of the cells to get the desired output in the following three conditions:
- If A1 is filled and B1 is blank the formula must consider date from A1
- If A1 is blank and B1 is filled, the formula must consider date from B1
- If both the cells are filled, the formula must consider date from A1 only.
is there any possible way for this?
Thanks in anticipation