Formula

Hello Tracey,

Thank you for your question regarding date formulas in Excel.

I'm not exactly sure what are looking for here. Correct me if I am wrong, but I think you may be referring to custom formatting. If I am correct then you can do this as follows:

Assume a date has been entered into a cell e.g. 10/05/2013

Excel often will format this as 10-May without mentioning the year. To fix this select the cell containing the date and then from the Home ribbon click the top drop-down in the Number group choose Custom and in the Type box on the right hand side type the following:

dd (this is for days and will show as a number displaying 2 characters)

mm (this is for months and will show as a number displaying 2 characters)

yy (this is for years and will show as a number displaying 2 characters)

You can add special characters between these letters to separate the three sections as follows:

dd/mm/yy (10/05/13)

dd-mm-yy (10-05-13)

dd/mm/yyyy (10/05/2013)

dd-mm-yyyy (10-05-2013)


If this is not what you are looking for please reply to this forum post and provide me with more details.


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer