How to use Edate function in different date format

[Leviathan]

Hi,

I want to use Edate function in excel in U.K. date format i.e. 23th December,2017; 23/12/2017. But when i use this function with the format it returns a !Value error, however this function work fine with U.S. date format i.e. 12/23/2017.

Please help me in this regard.

[affan · Accepted solution]

Hi @Leviathan,

Change your system windows date format. If you are using windows 8 or above, go to settings and then 'change the date and time format'.

Change the short date format to dd-MMM-yy

If this helped you, please mark this post as an accepted solution and like to give KUDOS .

Regards,

Affan