Free Microsoft Excel 2013 Quick Reference

autofill current date / time

I want to be able to autofill the current date (and time if possible), when an entry(text or number) is made in an adjacent cell. Is this possible?

This entry shd. automatically fill in a protected sheet /cell

thks


I need a way to save the file with the current date/time appended to the original filename (ie put a "time stamp" on the saved file).
Can anyone solve how to do this? Much appreciated.

My current approach doesn't seem to work:
I use Macro (1) to change the "save as" fields in Macro (2) to the current date/time. But Macro (1) doesn't work.
Note: Macro (2) saves the file with the current date/time appended to the original filename.

OK I'm learning to USE the Record Macro feature on a spreadsheet and I need
the sheet to do two things:

I need to be able to have a macro SAVE the file as the current date/time
using a set formating.

At the moment I have a cell set up for the NOW() command that gets updated
at the beginning of the Macro. When I go to "Save As" the macro record
feature can't seem to compute that the value in the File Name block is the
value from another cell displaying only the result of the NOW() command.

I'll neet to make a button for it when I'm done. But I know there's a
tutorial online for the button.

My programming skills are very much in their infancy. So I don't understand
a whole lot of the lingo. I do appreciate anyone that's got an idea on how
to make this work.

-Jacob Roecker

OK I'm learning to USE the Record Macro feature on a spreadsheet and I need
the sheet to do two things:

I need to be able to have a macro SAVE the file as the current date/time
using a set formating.

At the moment I have a cell set up for the NOW() command that gets updated
at the beginning of the Macro. When I go to "Save As" the macro record
feature can't seem to compute that the value in the File Name block is the
value from another cell displaying only the result of the NOW() command.

I'll neet to make a button for it when I'm done. But I know there's a
tutorial online for the button.

My programming skills are very much in their infancy. So I don't understand
a whole lot of the lingo. I do appreciate anyone that's got an idea on how
to make this work.

-Jacob Roecker

Hello,

I have a button on my sheet and when the user presses it I want my Label to display the current Date & Time. This will allow the user to
a) know when the sheet was last updated and
b) communicate that the button was pushed and the data was updated successfuly.

I know this is super easy but don't know the exact code, here is what I have included in my command button click subroutine.....

What's incorrect with this?    And also, how can I modify the date & time formatting, or where can I learn how to do
that?

Thank you so much,
Robert

Hello

Thank you in advance for any help with this. I work with a file that I would like to archive upon closing as the current date/time as the file name. I found some help with this earlier, but the file saves only as the current date. I would like it to save as the current date and time. Overall the goal is to stop printing or manually saving the file. Again thank you the help. I'm just starting to venture into the programming world.

Below is the script that I'm trying to use
---------------------------------------

Private Sub Workbook_BeforeClose(Cancel As Boolean)
  Dim Msg As String
  Dim ans As Integer
  Dim fname As String
  Dim MyDate
  Dim MyMonth

    MyDate = Date
    MyMonth = Month(MyDate)

    Msg = "Would you like to archive this file?"
      ans = MsgBox(Msg, vbYesNo)
        If ans = vbYes Then
           ThisWorkbook.SaveAs Filename:="C:Backup" & MonthName(MyMonth) & "-" & Day(Date)
& "-" & Year(Date) & "-" & ThisWorkbook.Name
        End If

End Sub


This is my first post and I am just introducing myself to the VBA world and was wondering if anyone could help me with this problem.

I am trying to create a code so that when the save button is hit, it puts the current date and time into a given cell before it saves. This way I will know the last time something was updated and saved.

Thanks in advance

I would like to be able to track progress of various tasks/occurences by allowing users of a spreadsheet to just click in the appropriate column and in doing so, it would fill in the current time and date. I.E. Column headings would read, "Item Sent to Review", "Item Received From Review", "Item Sent to Specialist", etc. and I want users to be able to double click in a given column to populate with current date/time information, how can this be done?

I'm trying to save a file with current date and time...I used the code from the following thread:

http://www.ozgrid.com/forum/showthread.php?t=65552


	VB:
	
ActiveWorkbook.SaveAs Filename:="C:FinalOutput.xls " & _ 
format(Now(), "mm_dd_yyyy hh mm AMPM"), FileFormat:=xlNormal, Password:="", _ 
WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Now when I try to run the macro, it gives me an error saying: Compile Error, Wrong number of arguments or invalid property assignment. And it highlights "format" in yellow.

Can someone please help me here?

HI,

I am using =NOW() to insert the current Date and time in my spreadsheet.

It looks like this... 11/12/2007 19:50

Is there any way to get the time not to be military time?

so it reads

11/12/2007 7:50

?

Thanks,

Barry

I have set up a workbook as a template and I would like to have the current date and time appear in the cell when the template is open. Can someone help
Thanks

To insert static current date and time Ctrl+ and Shift+ are supposed to work.
They have no effect when I use them. I'm using an IBM laptop.

Is there another way to put in a static date and time?

hi,
I want to show current date & time in column B when cells in column A is change.
my formula is change all date when the last cell change

thanks in advance
herukuncahyono

Helllo all,
I was wondering if there is a formula out there that will put in cell A1 the date/time the data in cell B1 was entered. The best I could come up with was =if(B1>0,now()," "). The problem with this formula is the date/time stamp updates with the current date/time with every calculation and I need the worksheet to calculate automatically. What I need is for the date/time returned to remain stagnet/locked unless the target cell (B1) is updated with new data. Any ideas?? I would think there's something easy out there but for the life of me I just can't think of it so this is a tad bit embarrassing to even ask although all help is very appreciated.

Thanks, Rick.

I'm trying to use EXCEL to capture transactions. For each transaction record,
I need to get the notebook system date & time. I use the "Now()" function,
but each time I hit enter all the values in the column changes to the current
date & time values. Is there another function/fomulae?

Hello experts,
What formula should I use to show # days left, including time (in hrs,
mins and sec's) from current date/time to a target end date/time?
For instance:

Start Date: Now()
End Date: December 31, 2005 5:00:00 PM

Your help is greatly appreciated.
Marie

I'm hoping someone might be able to help...I am trying to set up a date/time calculator to show how long is left until an event occurs, for example a Lease on a building is scheduled to expire at 12pm 24/12/03, so between now an the Expiry = x "yrs" x "mths", x "days" x "hrs" x "mins", x "sec".

I have got the first part working which is for the current date/time (NOW) to update on the screen. What I am struggling with is to get the "Time To Go" to calculate and update on the sheet. I have attached the test file.

Hi all, does anyone know if there's a command (or workaround) to get the current date/time in the format yyyymmdd hh:mm:ss?

Thanks!
Shawn

Hi guys,
I need help deleting rows which contain a cell with date / time in the format dd/mm/yyyy hh:mm if the value is older than the current date / time

any ideas?

thanks

when i utilize the NOW() function on my spreadsheet with the NETWORKDAYS() function in this format NETWORKDAYS(A3, NOW()) the formula is working correctly in that it is calculating the days how i want it to except that excel's internal clock or soemthing is behind. when i do =NOW() just by itself it works correctly and has the current date/time of my computer, but with that formula the days calculated are lower then what they should be. it seems to be that way across the board, if i were to put 1 feb 12 in b1 and this formula in a1 =if(b1="", "", networkdays(b1, now())) it calculates and forms a number in this instance for today it says 36, which is about 13 short, and if i put the same formula in a2 and put 3 feb 12 in b2 the number shows up as 34 so i know it is calculating correctly its just the internal clock it goes off of for this formula is screwed up. any help would be appreciated. thank you.

Looking for code that prompts a user to enter a date and time (eg 02/02/2011 8:31 PM) and then pastes that date/time into another cell (eg A1). I would like the user to be limited to the date/time format I provided for consistency and calculations.

It would be even better if the code could default to the current date and time and then ask the user, "Do you want to use the current date/time?". They would then choose "Yes" or "No". If the answer is "Yes", the current date and time would be pasted in the aforementioned spot (cell A1). If the answer is "No", the user would have the option to type the current date and time and have that data input pasted to A1.

Any help woul be greatly appreciated.

The current date/time stamp is below:

9/2/2009 8:59PM

I need to keep the date but remove the time stamp on the data. I have been using the formula below:

=MONTH(A1) & "/" & DAY(A1) & "/" & YEAR(A1)

But now it is giving me a !value error. Can anyone help? THanks!

I need help writing a function to display the date and time in cell B1 when any text is entered into A1. Using =if(A1<>"".NOW(),"") will display the current date/time in B1 but each time I open the spreadsheet up it will change to that current date/time. I understand that in a shared workbook that I can't use a Macro. Is that correct? Can a function be wrote that says that if a date/time has been found in cell B1 do not update that date/time? Thanks.

Hey,

I have a column with dates + time under this format :

2005-01-01 00:00:00

I wanted the same thing for the whole year, so, I wrote

2005-01-01 01:00:00

in the cell below, and then did an autofill.

Unfortunately, at some point, the cell goes from
2005-01-05 03:00:00
to
2005-01-05 03:59:59
which is a problem for me, because I was using the hour as an indicator.
And hour(2005-01-05 03:59:59) returns 3 and not 4!

Any solution?

thank you!
Nathalie

I am looking to have a macro which will automatically add the username and date to a cell, when the cell above changes (or in this case =x). I have a bit of code from a previous project, but I have changed Target.Row to Target.Column and it is not behaving as I require:


	VB:
	
 Range) 
    If Not Intersect(Range("B2:BZ2"), Target) Is Nothing Then 
        Range("C" & Target.Column).Value = Format(Date, "dd-mmm") & " " & Format(Time, "hh:mm") & " by " &
(Application.UserName) 
    End If 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Please see the attachment for the example. What I need is whenever row 3 ="x" I need the corresponding cell in row "d" to update with the latest date, time and username. Please not the macro is currently not active on the sheet as i've added the ' character. Please remove this when you take a look.

Many thanks in advance for your help.
Tom