Excel 2007 days and dates issue?

Solved/Closed

dfernandez - Jun 5, 2010 at 05:35 PM
rizvisa1 Posts 4479 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.

Excel 2007 days and dates issue?
Save as pdf office 2007 - Download - Other
Excel date format dd.mm.yyyy - Guide
Skype last seen days ago - Guide
How to add days to a date in excel - Guide
Transfer data from one excel worksheet to another automatically - Guide

1 reply

Answer 1 / 1

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Jun 5, 2010 at 05:45 PM

DAY() is supposed to give you the day of the month (1-31)

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.

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
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

Subscribe To Our Newsletter!