Month function

Hi Jack


Thank you for your question regarding the Month function.

The Month function should work in exactly same the way with U.S date formats as it does with UK date formats.

Select the date/s - if necessary format to US
- right-click, selecting format cells. Under the Number tab select the date category, changing the Location to English (United States) and then choosing the relevant date format.

Then proceed to use the Month function in exactly the same way you would with UK dates, Excel should still be able to identify the month.


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.



Kind Regards,


Nafeesa

Microsoft Office Specialist Trainer