| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Year showing 1899 instead of 2009
How do I get the following to give me 2009 instead of 1899 in immediate window?
? Year(today) produces 1899 rather than 2009 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Year showing 1899 instead of 2009
TODAY is a worksheet function, not a VB one. Use either one of these
instead... ? Year(Now) ? Year(Date) -- Rick (MVP - Excel) "Bob Zimski" wrote in message ... How do I get the following to give me 2009 instead of 1899 in immediate window? ? Year(today) produces 1899 rather than 2009 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Year showing 1899 instead of 2009
Debug.Print Year(Now)
HTH, Eric "Bob Zimski" wrote: How do I get the following to give me 2009 instead of 1899 in immediate window? ? Year(today) produces 1899 rather than 2009 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Year showing 1899 instead of 2009
Or try...
?year([today()]) -- Jim Cone Portland, Oregon USA "Bob Zimski" wrote in message How do I get the following to give me 2009 instead of 1899 in immediate window? ? Year(today) produces 1899 rather than 2009 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Year showing 1899 instead of 2009
On Mon, 23 Feb 2009 13:48:35 -0500, "Rick Rothstein"
wrote: TODAY is a worksheet function, not a VB one. Use either one of these instead... ? Year(Now) ? Year(Date) In addition, under VBE - Tools - Options, check Require Variable Declaration. That way VBA would not try to interpret 'today' as a variable. And it's just good practice. -- Dick Kusleika Microsoft MVP-Excel http://www.dailydoseofexcel.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change date format year to another (e.g., from 1/2/2010 to 1/2/2009) | Excel Discussion (Misc queries) | |||
| Copy from one worksheet to another changes the year from 2009 to 2 | Excel Discussion (Misc queries) | |||
| how to calculate $1000/year at 5% for 25 years showing each year | Setting up and Configuration of Excel | |||
| Cell won't accept date past year 2009 | New Users to Excel | |||
| Excel cut/paste prob: Adds one day and changes year to 2009 | Excel Discussion (Misc queries) | |||
Linear Mode
