Please help!! WEEKDAY function

[mahermustafa]

Gentleman,

I know this is weird but the WEEKDAY function works fine till 12/5/2015, any day after this it returns #VALUE .

i mean 12/5/2015 will return 6 but the next day 13/5/2015 will return #VALUE .

Not sure what is happening. Any help?

 

[Fluff]

Sounds like you system is set to use dates in the format MM/DD/YYYY but you are trying to use DD/MM/YYYY

 

[mahermustafa]

Sounds like you system is set to use dates in the format MM/DD/YYYY but you are trying to use DD/MM/YYYY

Thank you so much it works.

 

[Fluff]

You're welcome & thanks for the feedback