#1
|
|||
|
|||
How to call current PC date and/or current PC year
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 |
#2
|
|||
|
|||
=DATE(YEAR(NOW());MONTH(NOW());DAY(NOW()))
=now() =YEAR(NOW()) Go download excel function dictionary, it's a great tool.. |
#3
|
|||
|
|||
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 |