Previous Topic Next Topic

Excel 2007 days and dates issue?

Solved/Closed
dfernandez - Jun 5, 2010 at 05:35 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 5, 2010 at 06:17 PM
Hello,

I was working to have the week numbers in excel and i step into a question when i entered in cell "B1" the date 05/1/2010 and i changed the cell format to custom -> Type: dddd and it said "Saturday" but when I used the =DAY(B2) and the same cell format it said "Sunday" and the same happens for all other dates.

Does anybody know if this is a glitch or i am doing something wrong.

Thanks a lot in advance.

Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 5, 2010 at 05:45 PM
DAY() is supposed to give you the day of the month (1-31)
1
dfernandez
Jun 5, 2010 at 05:56 PM
Thanks. Now I get it, that means that since excel understands the dates counting from 1/1/1900 as date 1 and 1/1/1900 was a Sunday and so on. Thanks a lot i was confused.
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 5, 2010 at 06:17 PM
right on money. day(), month() and year() are useful to get the parts of the date. If you want the weekday of a day, you have to use function WEEKDAY(). read the help on it though as it has an optional 2nd parameter which decide what is to be considered as first day of the week
0

Similar discussions

encryption message several time in chat
measking -
HelpiOS -

1 response
Can’t access settings for a few days lock out
Rak7 -
HelpiOS -

1 response
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses