Dates In VBA

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

Guest

All of my dates in my user defined functions are being returned as the date
plus 4 years and 1 day. Even the Now function returns todays date plus this
time. why?
 
Hi wienmichael

See

Tools>Options..Calculation

See the checkbox in 1904 date system
 
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

WeekNum Trouble 4
Supressing a #VALUE! error returned? 3
Add one year in second combobox in vba 0
Mid-Month function help 3
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Excel Formatting with dates 3
Excel Vba to change displayed year automatically. 14
Date subtraction 1

Back
Top