Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-01-2011, 12:25 AM
KIM SOLIS KIM SOLIS is offline How to call current PC date and/or current PC year Windows XP How to call current PC date and/or current PC year Office 97
Novice
How to call current PC date and/or current PC year
 
Join Date: Sep 2011
Posts: 29
KIM SOLIS is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 11-01-2011, 10:55 AM
Catalin.B Catalin.B is offline How to call current PC date and/or current PC year Windows Vista How to call current PC date and/or current PC year Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

=DATE(YEAR(NOW());MONTH(NOW());DAY(NOW()))
=now()
=YEAR(NOW())
Go download excel function dictionary, it's a great tool..
Reply With Quote
  #3  
Old 11-04-2011, 06:09 PM
KIM SOLIS KIM SOLIS is offline How to call current PC date and/or current PC year Windows XP How to call current PC date and/or current PC year Office 97
Novice
How to call current PC date and/or current PC year
 
Join Date: Sep 2011
Posts: 29
KIM SOLIS is on a distinguished road
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to call current PC date and/or current PC year 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
How to call current PC date and/or current PC year Cells from other worksheets apear on current worksheet Equilar Excel 3 05-03-2010 01:40 AM
How to call current PC date and/or current PC year 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft