current date

  1. S

    current date shortcut key in Excel online

    Hello, In Excel 2016, the shortcut key for current date is CTRL + ; For current time the shortcut key is: Shift+CTRL+; Are there similar shortcut keys in the online version of Excel? I can only find basic shortcut keys for navigation etc... Thanks
  2. F

    Possible to ignore column until a certain date?

    Is there a way to ignore a column until a certain date arrives? For example, I have some columns splits up in Quarters. <tbody> A B C D E F 1 Q2 17' Q3 17' Q4 17' Q1 18' Total 2 1 0 1 1 0 3 0 1 1 1 0 </tbody> Using the guide below, Q4 17' and Q18' need to be ignored until the first...
  3. D

    How to auto refill userform textbox ( auto number , curent date ) after clear ?

    Hi , I have a file whit a user form created , whit auto number in text box 1 and current date in text box 2 which works well when open.My problem is that when clear button is applied on the form or after "ok" button is press ( and data entered) ,and clear form is applied to ad new data ,the...
  4. R

    Clicking a macro button to add date to a cell in the same row as the active cell

    I need a macro that when a button is clicked, after selecting an active cell in A:, the current date will be put into the same row, column AM.This date will be a time stamp so it shouldn't change when the file is opened the following day.
  5. A

    Excel Date Picker Not Selecting Current Date

    Hi y'all! So I have the following code: Private Sub Calendar1_Change() ActiveCell.Value = Calendar1.Value ActiveCell.NumberFormat = "mm/dd/yyyy" ActiveCell.Select End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub...
  6. Prevost

    Display current date on excel calendar

    Hi There, I have read some posts but I am still unsure about this. I have a macro on my sheet that runs whenever I double click certain cells. The calendar pops up and I can select a date from that calendar. Now I know that the calendar date defaults to whenever the calendar was created...
  7. C

    dynamic pie chart

    I have a table with months Jan-Dec in the top row, data in rows 2-5 and totals in 6. I have a pie chart that shows the percentages of the current month in relationship to only that month's total. Each month I must "slide" over the source data to the new month in order to show solely the most...
  8. K

    Insert a button in excel such that when u press a the button it moves to current day.

    Hello everyone, I have a excel file that has all the dates for year 2012. I check this everyday for updates on each day for a specific date. Usually i am trying to look for todays date. I am fed up of scrolling up and down everyday to find it. Is there a way when i press a button for...
  9. N

    Dynamically updating chart

    I would like to create a line chart that updates daily. I think I've gotten the data to update and show up automatically, I just can't figure out the chart. Basically, I want to have the chart to add the values from each day as the days happen, but to not display future dates and values...
  10. A

    Copy paste based on current month

    Is there a way to copy a range of cells based on the current month? Something like this maybe: if systemMonth=12 then Range("A1:D12").Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _:=False, Transpose:=False else...

    Help with counting # of workdays

    I did spend some time searching the forum but couldn't find an answer. This will be a piece of cake for all you Excel geniuses...:) Have spreadsheet with the following columns: Date Received - date a work item is received Date Completed - date a work item is complete Days To Complete - # of...
  12. R

    Opening excel so that it automatically goes to today's date in the list of dates for the year

    I have an excel document which is set out like this: <TABLE style="WIDTH: 401pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=534><COLGROUP><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3730" width=102><COL style="WIDTH: 54pt; mso-width-source...
  13. H

    Current date formula for

    Formula result must be ... eg 14.07.2010 Tried but does not work ... =DATE(day.month.year) =DATE(
  14. P

    "end of week"

    I'm wondering if there's a way to set a formula that updates to the upcoming Friday based on the current date. For example, if the current date is Thursday, March 5, 2009, this formula would return an answer of Friday, March 6, 2009. Once the date becomes Saturday, March 7, 2009, this formula...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...