now function

  1. D

    Workbook SaveAs private function to include date & time stamp - saved file won't open

    Hi Folks, I discovered some VBA to be able to save a workbook with a custom filename that contains date and time stamp. My goal is just to save the file as *.xlsx. The code below works in regards to saving the workbook with the bespoke filename; however, when you try and open the workbook...
  2. M

    Need help with VBA for today() and now() functions

    I need a macro code inserted into my workbook that will stop the Today() and now() functions from recalculating every time a change is made in the work book. Students will be typing in numbers in columns A and E. When their number is inserted in column A, the "name"(column B), "date"(column C)...
  3. M

    Function =now() in barcode format

    Hi I am working on a data sheet for users, the idea is to capture the current date & time by scanning an external laminated barcode, there are various activities happening in the room, and, as and when a particular activity is completed, the supervisor scans a barcode (the barcode remains the...
  4. B

    Application.Username & Now Function macro

    Hi Guys, I hope you are all well. I was just wondering if anyone can help me I am just looking for a simple sub that simply puts the Application.Username in column E and Date and Time in Column F each time the macro is used and will create a list of Users And Login Times. any help would be...
  5. A

    Independant time stamps ...

    Hail Excel-lent ones. I've used this site often in the past to much success, but I've found a problem I'm not sure how to work around. I need two independent time stamps to be auto-filled based on the completion of adjacent cells. This part works in generating the stamps, but updates when the...
  6. A

    Now() Function not saving date correctly

    Hey everyone! Thanks for any input on this issue I'm having. I have a workbook that has assignments that get done throughout the month. I need the date to autopopulate based on criteria so I am using the IF() and NOW() functions. The date populates fine, except if I save and close and then...
  7. J

    If Activate Command Results In Run Time Error, Then Test a Second Option

    All, Apologies for the vague title - could not find a good way to word it. This thread plays off a recently posted one that a member was very quick to answer and get me on my way. I have a file name of "May Scrap Net of Reserve with scrap codes.xls". My earlier post centered around how to...
  8. A

    Month(now()) help!

    Need some help with the MONTH(NOW()) Function, as I need it to reference the month preceding the current month. Can anyone please help?
  9. N

    Inserting a changing date and a static time

    Hi...trying to find a way to insert/format the date in excel to be today date (will change everyday) but the time must be static at 4pm or 16:00. It defaults to 00:00 or 12:00AM so if theres a way please let me know. E.g i have on column with dates: <TBODY> Expiry</SPAN> 8/17/2012</SPAN>...
  10. E

    Help with Date and Time Return

    I am creating a Call Sheet to record Times, Dates, and Notes that the listed parties were contacted. The end goal is to be able to enter in a cell the notes from the call, then an adjacent cell will read time that the notes were entered. Is there a way to get the return of when a cell was...
  11. O

    Now Function suddenly produces error... help!

    Hi All. I have macros with this line of code: Application.Wait now + TimeValue("00:00:01") the macros have been working perfectly for months and then suddenly I get the word 'now' highlighted and this error in vba: Compile Error: Expected function or variable. What's happened and how...
  12. C

    Last Update timestamp w/o VBA

    Hello all! I am wondering if there is a non-VBA way to have a cell in a worksheet display the last time that worksheet was updated/modified (or maybe last time it was saved?). I know how to do this using VBA, but was wondering if there was a built-in function or some way of using the NOW...
  13. D

    conditional formatting based on time difference

    I am having trouble creating rules for conditional formating based on the time difference between a static time value in a given cell (time due completion) and the NOW function. I would like to have the format of cells change as the time difference changes. I would like to have cells that are 4...
  14. D

    Now Function

    Hello, How to keep the date in the cell when I use "Now()" function? Example: I use: =IF(A38<>"";NOW();""). When i enter something in cell A38, I have the current date entered. I save and close the workbook. Two days later I open it, and now function recalculates the date. How to keep it. I...
  15. G

    Application.WorksheetFunction(Now) getting error

    Dear All, I am using Excel 2003 with Windows XP on a network. I keep getting errors with some code. In a sheet, I have: Sub GetUser() Range("Created").Value = Application.WorksheetFunction(Now()) Range("Author").Value = Application.UserName End Sub The code for the Author works perfectly...
  16. N

    updating date every time particular cells' contents are changed

    Hi, I am working on a spreadsheet where I wish to have a column B where each cell shows the date on which the cell in the corresponding row of column A is manually updated by me. In other words, <table style="border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="484"...
  17. P

    Incorrect time displayed in cell

    I'm trying to create a invoice number cell that incorporates the account number from cell C3 and the date and time the invoice was created. I entered this in the cell: =C3&" "&TEXT(A12,"MM-DD-YY-HH-MM ") It does bring in the account number and the correct date, but the time displays as 0-00...
  18. melewie

    minus 1 year from now function

    Hi all<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I have a spreadsheet with dates people started the company I need to figure out if they have been here over a year. In have tried several different ways and have figured out a few long...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top