Hello everyone,
I want to get the DAY of the DATE like (Sunday, March 04, 2007
), and I use the formula =DAY(Sunday, March 04, 2007), but unfortunately it return the Wednesday. but on some date it works correctly.
Can anyone plz tell me How it is possible to get the exact DAY of a DATE.
I want to get the DAY of the DATE like (Sunday, March 04, 2007
), and I use the formula =DAY(Sunday, March 04, 2007), but unfortunately it return the Wednesday. but on some date it works correctly.
Can anyone plz tell me How it is possible to get the exact DAY of a DATE.