current date

  1. D

    VBA Conditional Statement That Functions Based on Today's Date

    Hey everyone! I am currently trying to implement a function into a workbook that has many worksheets. Each worksheet has individual dates stored in cells E1:R1. When the workbook is opened I want the code to immediately run (so I put it in the Workbook_Open sub). The code looks through each...
  2. D

    VBA to Conditionally Reorder/Move Sheets Upon Workbook Open

    Hey all, I have a workbook with a tab named 'References' Based on the current date, I would like the 'References' tab/worksheet to be assigned/moved as follows. If today's date falls between: 'References' Sheet Position in the Workbook Jan13 - Jan26 3rd tab from left Jan27 - Feb9 4th tab...
  3. D

    Open Certain Worksheet Based on Current Date

    Hello everyone! Back in 2018 you guys helped me with some VBA code that would set the color of a certain tab in a timekeeping/pay period workbook depending on the date. (see Tab Color Dependent on Date) With a few tweaks over the years, the code used in the solution has worked flawlessly over...
  4. 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
  5. 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...
  6. 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...
  7. 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.
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  15. 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...
  16. H

    Current date formula for

    Formula result must be ... eg 14.07.2010 Tried but does not work ... =DATE(day.month.year) =DATE(
  17. 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back