Date formats in cells

  • Thread starter Thread starter Phil Amey
  • Start date Start date
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date format 1
Preserving date format 1
Convert mm-dd-yy to mmm so pivot table reads mmm not mm-dd-yy 1
How do I delete merged cells in Excel without deleting the final d 5
Conditional formatting of date-cell - 2007 5
date 2
Count Between dates 11
Wrong date format in header 1

Back
Top