date

Hi, I need VBA code that will rename the current sheet based on the value of a cell (B2) in that sheet. That value is a date in format YYYY-MM-DD and I need the sheet renamed in format M-D. Example: Cell B2 shows value "2022-12-20" -> sheet must be renamed "12-20" (excluding quotation...

I am creating a schedule within excel with days along the top, time down the left and activities populated in the table. The column headers/dates are not stored as dates, but as unique values based on our calender (e.g. Week 1 Mon, Week 1 Tue). I would like something that means if I type in...

Hello, I'm having an issue trying to bring multiple data sources with date X-axis values into the same chart with a VBa macro. The chart "scales" to the first series added or whichever is set as the source data. When the other series' are added, I think they might be unwittingly "discretized"...

Hi All - as it states in the heading, I'm looking to either amend the code below or obtain a new on where I can copy the workbook I have open to the same folder but with the Week ending date (Sunday) added to the end of the file name. I found this code (Credit: @swapnilk) that gets me going...

Hi all, I wondered if there was a clever/efficient way of checking if multiple columns with dates in, fall within a date range, see below table. I want to check if any of these dates fall between the 25/12/2022 and the 02/01/2023. I know I can do repeating if statements, but thought I'd check...

Example : Date in A5 = 31/10/2022 Cell B9 = =EDATE(A5,-3) gives me 31/07/2022 Cell A9 = =EDATE(B9,-3)+1 returns 01/05/2022 These results are great. But when I change the date in A5 to 30/11/2022, dates in B9 changes to 30/08/2022 (which is not the last day of that month) and A9 returns...

Beginning of month 01/01/2022 01/02/2022 01/03/2022 01/04/2022 01/05/2022 01/06/2022 01/07/2022 01/08/2022 01/09/2022 01/10/2022 01/11/2022 01/12/2022 Net working days 21 20 23 21 22 22 21 23 22 21 22 22 This part data and I have a separate sheet where I am gathering data for each month...

Hi guys, Trying to check if a date is between a range of dates in a table with date ranges. So, I have a table with two columns, col C is first day of vacation and col D is last day. And I'm trying to come up with a function to tell me if a given date is inside that range. I'm toying with...

I have a date field with today() that returns current date. I need for it to remain date when shift starts. The shift is from 6PM to 6AM. When form is being updated throughout the shift, the date changes to the next after 12 midnight. Is there a way to enter date automatically without it being...

Hi all, I am trying to make a column of all the dates in September written in the format "dd-mm-yyyy": However, if I write "01-09-2022" and try to pull it down (as seen above), it just keeps posting "01-09-2022": Likewise, if I try to fill out more cells with "02-09-2022" and "03-09-2022"...

Hello, I got a macro button which adds month sheets for a specific year that is entered in an inputbox. The following code unsuccessfully attempts to fill all working days with a pink colour if they match a range of cells that represent the holidays (and include blank cells). Is there a way to...

Hi there, i need a hand to help me with a simple VBA code, i got my sheet1 here ABC1DateTeamName205/10/2022ALupin322/10/2022AFox405/10/2022BRuby522/10/2022BSusan605/10/2022BGarland705/10/2022AAnthony and here is sheet 2, i simply want to list their name in sheet2 here which matched their date...

I run a maintenance business and I've decided to make an excel sheet that tracks if my technicians are keeping up with their service on a weekly, biweekly, or monthly basis. I figured the easiest way might be by changing "biweekly" to 14 and "monthly" to 30 like I set up the true/false...

Greetings Excel Community, I have numbers formatted in the following Text or general format: 20221026.. I am trying to format it as mm/dd/yyyy.... I have used a formula as follows but it is not generating the correct output: Formula is =DATE(LEFT(G2|4)|MID(G2|5|3)|RIGHT(G2|2)). I am including...

=TEXT("G" & ". " & G10 & " - " & INDIRECT("G"&L1),"mm.dd.yy") Returns date's serial: G. Image In Date - 44648 Instead of date itself, G column contains that date in it: G. Image In Date - 03.28.22

Hi Team, I want to validate my inputs so no unnecessary data will be entered. Please show me how. Date Rego# (eg:ABC123): 3x ALPHABET & 3x NUMERICALS Time Out & Time In. Date Rego# Driver Name Type of Vehicle Trip remarks Load remarks Destination Time Out Milage- Out Time In Milage- in...

Hello All, I need a formula that looks back 11 weeks from a given date and returns the Sunday at the beginning of that week. - Example, 27/10/2022. 11 weeks prior is 11/08/2022 and the Sunday beginning that week is 07/08/2022. The formula would return 07/08/2022. I also need one that looks...

I have a situation here with me and I need someone to help me to fix it. There are two textboxes which contain dates That is textbox1 and textbox2 Then I have two columns with dates as well. Thats columns AO and AP. AO3 and AP3 are headers with the labels START and ENDED respectively. Now...

Good morning, I'm having a hard time trying to figure out a macro that will update the yyyy-mm(+1) in a specific cell. It needs to include the ' at the beginning as that year-month is used to update the table below it. Example: It is currently September 2022 right now. I would need the macro...

Hi, I have a column with various dates in it (column AK). Scenario: Today's date (Tuesday 13/09/2022) if date in AK2 is between Monday 05/09/2022 and Friday 09/09/2022, then return the value of "Yes", otherwise "No". So next week the Monday's date would be 19/09/2022 and the previous Monday...