date

Hello, I'm building a macro that will perform a data pulling operation each day when I run it. This part of the macro runs great. But, at the start of each month the data should be scrapped and the data storage worksheet should start again from zero. The idea that I have is to bracket my...

I've got a data set of 6,133 rows with cells of dates in the following format: Cell A1: Status A-2022-02-03; Status B-2022-03-11; Status C-2021-09-10 This is an example of the content in a given cell and I want to separate the statuses and their respective dates into separate columns (by using...

Greetings Excel Community, Below I have some Test data where the Unique ID has a relationship with the "Value" column. For each UniqueID, there must be a corresponding row from the "value" Column. What I am trying to accomplish is a formula or VBA Script that will split the UniqueID into its...

Hi all, I am very new and very inexperienced, I hope someone can help me. I have 2 questions see below first one: I want to find duplicate dates for my database, but not working. I want to show how many duplicates too. Private Sub Textbox3_afterupdate() Set rng = Range("E2:E3000") Dim ws As...

I need a formula that will display “if a selected date +21 days is at least 30 days from the 1st of the next month, then display the next month. If less than 30 days from the first of the next month, then display the next month + 1 month.” For example, if a selected date is 9/11, then 21 days...

Hello, I'm trying to figure out how I can select a range based on a date within the current week. Example of selection… The order I'm trying to step through is the following: 1. Declare Friday as a variable to store the date using a formula: =TODAY()-WEEKDAY(TODAY(),16)+7 As of today...

I have a spreadsheet that have pay period dates, that run from V5 to AT5. We have the past pay months within 1 month grouped together and the future months within 1 month grouped together. For instance this month is August, so all the columns with dates in July, August, and September are not...

Hi all, I have a very large spreadsheet with value dates for each row, I normally filter it by dates and also use the “newest to oldest” filter but for some reason my dates are not formatted correctly so some are not included in the year drop down and instead are separate to the other dates...

I'm trying to use VBA to automate a process I perform multiple times a day. I've figured out a little bit but I've got 2 different columns containing time. The estimated time is sometimes populated so I want to be able to filter on 2 conditions: either ET (Estimated Time) is populated and...

Hi all, Finally getting somewhere with my data sheet but have come unstuck with calculating dates in VBA. I have a UserForm set up that the user can enter a "New User" name and then go through a series of 55 text boxes and enter the days remaining before they need to complete individual online...

Hi there, I am having problem creating a formula that highlights/shades a cell that has date within the next 6 months. For example todays date is 1 Jan 2023. I have two lease expiries, one on the 1st Apr 23 and the other on the 1st June 23 how do I have those cells highlighted? Both these...

Hi, I have the following fields / inputs: 1) 'Start date' - in this example 9 June 2023, cell AV11 2) 'First date' - in this example 1 July 2013, cell AU16 3) 'Frequency' - 365.25 (in days), cell AV14 --> this can take any numeric value, and would typically range from 1 to 365.25 I have...

Is there some VBA code that can password protect a workbook when a certain date is reached so the data cannot be viewed or edited by anyone without the password?

Hello, I am having some problem with dates I have 2 workbooks First workbook name is Test, there in sheet SQL2 in cell H2 I have a date I want excel to jump to specific column in other workbook (Data) which has same date as my number in cell H2 from Workbook test All dates in second workbook is...

Hello I have a Userform that I am using to enter data into cells in a row. One of those cells is to include a date. I want the date to be formatted "YY-MM-DD" (January 5, 2020 = 20-01-05). When I have the value from the userform entered into the cell it does not act as the date that it visually...

Hi All, I currently have a function that identifies which dates between two dates are Saturdays. What I also need to know though, is how to work out if any of those Saturdays appear in a list of specified dates e.g. Leave//Holidays list of dates. So the below example shows what I'm trying to...

I have a range (let's call it the A column) that has dates in this format: dd.mm.yyyy so I want to change the format to short dates d/m/yyyy Instead when I use range.replace, it takes the values as if it is in the mm/dd/yyyy format. How do I replace it. Sub format_dates()...

I am making a task tracking grant chart using 2 input value Start(Date and time) and Duration(Hourly), to calculate their Finish by simply just Start+Duration/24 as you can see in this sheet. ABCD1TaskDurationStartFinish2Task11201-Oct 06:0001-Oct 18:003Task21301-Oct 06:0002-Oct...

Hi all, I've put together a management information workbook which has a master sheet called 'Performance.' All of the remaining sheets are titled as the Monday of each week with a format ('dd.mm.yy'), i.e. today is 17.05.23, so this week's sheet is called '15.05.23.' I'm looking for code for...

Hi All, I have the following code to generate a Week number in column A and a date in column B every time a cell is changed in column C of my spreadsheet. Unfortunately it does not work for multiple entries. For example, If I copy and paste a group of eight entries, it only updates the first...