Hi there! Sorry if this is overly simple/asked a lot, but, I can't seem to figure out how to make a certain cell in excel 2010 update to the current date (not time) at the time that the document is saved.
Any help would be appreciated.
Thanks.
Hi there! Sorry if this is overly simple/asked a lot, but, I can't seem to figure out how to make a certain cell in excel 2010 update to the current date (not time) at the time that the document is saved.
Any help would be appreciated.
Thanks.
Last edited by Nickwixon; 03-07-2014 at 08:47 AM.
Try:
Change sheet / range reference to suit.Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Okay, great it worked! Now if I ever do want to add a time function, how would I go about that?
To show date and time, replace Value = Date with Value = Now.
To show just time, replace Value = Date with Value = Time.
Okay, excellent! Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks