LinkBack URL
About LinkBacks
Whenever I use the =TODAY() stamp I always get the time as well...I'm just looking to use the current date only.....any ideas?
Thanks
Whenever I use the =TODAY() stamp I always get the time as well...I'm just looking to use the current date only.....any ideas?
Thanks
Last edited by simpleonline1234; 04-30-2010 at 08:56 AM.
The Today() function gives the date. the NOW() function gives date and time. .. format the cell via Format|Cells Number tab. Then pick Date and select your preference.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
=today() is only for date. do you have an example of what you are seeing?
Sorry coffee hasn't kicked in yet....yeah the =Today() function is working great.....
Re: What is the formula to insert the current date without the time stamp?
This article should be definitely useful:
http://www.fundooexcel.com/2014/09/h...-in-Excel.html
http://www.fundooexcel.com/2014/09/h...-in-Excel.html
mashrani, thanks for the updateHowever, this thread is now over 4 years old, I doubt the OP iws still following it?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks