How do I add Text function in the formula?

[srizki]

In F2 I have =IF(ISODD(ROW()),"",E3
E3 had the date, so it brings the date in numbers like 43466 instead of 01/01/2019
how do I add "MM/DD/YY" in the formula? I can format the column as Date, but I need to learn how to add this into the formula.

Thanks

 

[ClaireS]

=IF(ISODD(ROW()),"",TEXT(E3,"mm/dd/yyyy")​

 

[Joe4]

You could just format the cell to a date format.
Otherwise, replace E3 in your formula with TEXT(E3,"mm/dd/yy").
Note the difference is that the TEXT function will return a Text value, not a date value. So if you need to do any math or sorting on the results, that could be a problem.

 

[srizki]

Thank you to both of you, I was adding "& before the TEXT.
=IF(ISODD(ROW()),"","&TEXT(E3,"mm/dd/yyyy")

thanks again.