I know the Formula is =Now() But how do I get it to show in this format? Year,Month,Day? I am using it to save the file with the date in the file name based on a cell value.
I know the Formula is =Now() But how do I get it to show in this format? Year,Month,Day? I am using it to save the file with the date in the file name based on a cell value.
do you want it separate or single cell?
single
Formula:Please Login or Register to view this content.
separate
etc? etcFormula:Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
=NOW() includes the tim e as well. Maybe use =TODAY() instead
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
In a single cell, but as; YYYY-MM-DD
Did you try the suggestion from post #2?
Just format cell where your formula is as Custom, and type in YYYY-MM-DD
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
AlKey, not sure that will work if they want to use the date in a file name. Got a feeling they will just end up with a 5-digit number
Ok. I will give that a try.
Nope it worked. Thanks so much everyone!
Thank you for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks