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
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.
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:
- Excel 2007 days and dates issue?
- Save as pdf office 2007 - Download - Other
- Skype last seen days ago - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- How to add 90 days to a date in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 5, 2010 at 05:45 PM
Jun 5, 2010 at 05:45 PM
DAY() is supposed to give you the day of the month (1-31)
Jun 5, 2010 at 05:56 PM
Jun 5, 2010 at 06:17 PM