days of the week are incorrect

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When entering 2003 dates the day() feature works corrcetly. However for 2004
it shows the wrong days.
 
It works fine, you probably misunderstood the function.
What do you excpect to get for let's say

October 18, 2004

?

You should get 18, what do you get?


Regards,

Peo Sjoblom
 
Hi

2003 is a Windows application, 2004 is a Mac application. They use different
calendars by default. Are you sure that the dates are what you think they
are on each system ? You can see day, month and year in the date cells on
both, and they display what you think they ought to ?

Best wishes Harald
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vba to change displayed year automatically. 14
Access Dateadd function question.. 0
Fried battery ? 3
Excel Monthly Spread sheet. 12
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Outlook Outlook To-Do Bar Not Showing 7-days Appointments 0
Calculating the first day of the week 5
Excel How to get the number of days an item was opened from the today's date. 14

Back
Top