current 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...

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...

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...

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

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...

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...

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.

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...

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...

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...

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...

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...

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...

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...

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...

Formula result must be ... eg 14.07.2010 Tried but does not work ... =DATE(day.month.year) =DATE(dd.mm.yyyy)

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...