Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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
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
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |