How to call current PC date and/or current PC year

KIM SOLIS · #1 11-01-2011, 12:25 AM

Hi,

This looks simple but i can't get it right:
a) How do I automatically call the current PC date, say in cell A5, as in '10/31/2011'?
b) How do I automatically call the current PC year, say in cell A5, as in '2011'?

Thanks in advance.

Kim

Catalin.B · #2 11-01-2011, 10:55 AM

=DATE(YEAR(NOW());MONTH(NOW());DAY(NOW()))
=now()
=YEAR(NOW())
Go download excel function dictionary, it's a great tool..

KIM SOLIS · #3 11-04-2011, 06:09 PM

Hi Catalin,

Ha ha ha.. i downloaded the reference u gave. great find. Thanks too for this latest advice. Good day to you. More power!!

Kim

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Access to the property of the current table	b0x4it	Word VBA	2	05-26-2011 06:25 AM
Current view filter applies automatically	lumisy	Outlook	3	03-25-2011 05:44 AM
Cells from other worksheets apear on current worksheet	Equilar	Excel	3	05-03-2010 01:40 AM
Auto insert current month's name and current year	Styler001	Word	4	01-25-2010 06:40 PM
Office hyperlink that closes current program	solarscott	Office	0	08-10-2009 11:57 PM