Forum Discussion

Leviathan's avatar
Leviathan
New Member
7 years ago
Solved

How to use Edate function in different date format

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's avatar
    affan
    7 years ago

    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

     

1 Reply

  • affan's avatar
    affan
    Solution Sage
    7 years ago

    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