P
Phil Amey
Is it possible to mix date formats in cells.
For instance. If I had a date format of dd/mm/yy in one cell (a1) and mmm-yy in another cell (a2) could I write an expression in cell a3 so
that:
If there is a date in a1 then use it but in the format of dd/mm/yy and if there isn't a date in a1 use the date in a2 but this time in the
format mmm-yy. So that the column would like this:
dd/mm/yy
dd/mm/yy
mmm-yy
dd/mm/yy
and so on.
Any help would be much appreciated.
Philip Amey
For instance. If I had a date format of dd/mm/yy in one cell (a1) and mmm-yy in another cell (a2) could I write an expression in cell a3 so
that:
If there is a date in a1 then use it but in the format of dd/mm/yy and if there isn't a date in a1 use the date in a2 but this time in the
format mmm-yy. So that the column would like this:
dd/mm/yy
dd/mm/yy
mmm-yy
dd/mm/yy
and so on.
Any help would be much appreciated.
Philip Amey