hi there again,
i would like to use some function like today()in my excel worksheet, but i don't want it to be change after a day change.
is this possible?
Thank you
great forum you have here
regards
hi there again,
i would like to use some function like today()in my excel worksheet, but i don't want it to be change after a day change.
is this possible?
Thank you
great forum you have here
regards
Last edited by trampy; 07-17-2011 at 05:00 PM.
You specify a static date using the DATE function.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Here is simple code to attach to a macro key or you can change the sub to a function and it will then become a User Defined Function.
AlanPlease Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Something like
In any cell test it by typing the formula =StaticDate(). Format the cells to show date eg dd/mm/yyyyPlease Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
You can also just press Ctrl+; to get today's date in the active cell.
Dom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks