date adding

For work, I'm creating a schedule that has automatically updating dates. In the first relevant date hex I've inputted '=DATE(year;month;day), which by itself works fine. Now, this afternoon I saved the excel file with the other cells referring to one another (and to the original) with the...

I have a spreadsheet of Civil War veterans which I am trying to get into genealogy software. Converting into real dates is the first task. If I have an Excel spreadsheet that has Column D2 as a day of the month, E2 as the number month of a year and F2 is a year, what formula do I use to have...

I have created a table which calculates a date using two fields. The three fields are Start date (Date field) Recurrence (Choice: Month, Year, 3 years) Next recurrence (Calculated column with date result) The rule is If Recurrence is Month the Next recurrence will be Start date - 1 day and + 1...

Hello everyone, I am working on a project employee capacity-sheet, with several projects and the capacity for each month. I want the percentages (D2:M4) shifted automatically when I, let's say, change the end date to 2023-05. How do I achieve this? Thank you so much in advance! :-)...

I am wanting STATUS cell to read "OPEN" if a date has been input in the RECOGNISED cell but "CLOSED" if a date has been input in CLOSED cell. DEFGHI2RecognisedForecastedActualClosedDays OpenStatus3424-01-2228-01-2227-01-2227-01-22524-01-2228-01-226I5:I10Cell Valuecontains...

Hi all, I am trying to make a randomizer in Excel to randomize my workouts. I currently have 4 workout lists in Excel: Abs, Arms, Chest, and Legs. The lists are made of strings with no numbers. What I want to do, is to have 3 different buttons, each for a different day (Arm, Chest, and Leg)...

Hi guys, how are you? Guys I don't know which one logic I need here to place dates by counties by months. I need place only earlier date in my Month cell. Example If I have date: 01.01.2020 , 05.01.2020 , 07.01.2020 then I need only earlier date from January = 01.01.2020 in cell Date 2020 I...

I am using below code in my userform in order to put todays date by default. The below code sets the date in the given format in my textbox :- Private Sub UserForm_Initialize() txt_date.Value = Format(Date, "d/m/yyyy") End Sub But when I click Add data, then in the sheet1 the Date column is...

Hi Evryone, I a new to VBA and trying to do a automation. I Hav a user unput date which stored in a string "strdate". now i want a code that looks for the date in row 3 of sheet1 and if the date is present it has to publish strdate + 7 days in the immediate next cell to its right. lets say...

Hello forum i have question which hopefully will have a quick solution i have a time sheet for the month, this is split into up to 5 weeks starting in B6 (5 columns per week). What i would like is a macro to populate the only the weekdays of the month, however if for example 01 March 19 is...

Hi guys, I have faced a problem I hope you can help me with :) I need to track on which date does a certain product reached a certain volume of sales: 500 units, 1000 units, 2000 units <tbody> Product Volume reached 500 2000 etc A 100 date date B 500 date date C...

Hi, I checked the other posts to the forum, but the tools were not specific enough. I'm attempting to display a due date based on the current date that coincides with the next quarter or week. Specifically, I want to know: - How I can find the Wednesday before the next month end - How I can...

Hi, I would like to know if there is a formula that could to create a date by looking for the highest date with the same criteria and then adding 1 day to it to make it greater. For example, in the below table I want the last row in Col E to look at item 932 and see that 11/3/2019 is the highest...

I'm working on a spreadsheet that has a cell for "Last Updated" (B5) - How can I get this to automatically update with the date when any of the other cells (C4:BH21) are changed? I don't want it to update just on opening/saving, only when physical data has changed. Any help really...

Hi folks, I am not sure how to Excel this problem. I have a series of start and end dates throughout the year, and over other years. For example: Start End Start End 2018-01-01 2018-04-01 2018-08-01 2018-12-01 I am trying to...

Is there a way to calculate to a the closest specific date following a year? I am looking to enter a date, and have Excel calculate the date after a year, and then calculate the either FIRST 2/1 or 8/1 after the 1 year date. IE: A1 would have 3/31/16 ... the 1 year would be 3/31/17 ... the...

I have a budget and I have pay period dates set up in say.... A1 is a set date, 01/13/2017 (first pay period for the year). I then have another cell, A20 with =A1+14 which gives me the next pay date and so forth and so forth along the months across sheets. Works great, well until you get...

First time poster I need to automate the following. every time i add a week (7 days) to B1 I would like the date in C1 to be increased by 4 weeks (28 Days) A1 B1 C1 <colgroup><col><col span="3"></colgroup><tbody> John Smith 21-Feb - 19-Sep...

Hi! I have a sheet that includes looks like the below table. What I would like to do is take the invoice date, add the terms and come up with a payment date that is rounded to either the 10th or the 25th of the month, since those are the days we do our check runs. Thanks! <tbody> Invoice...

Hello, I could use some help coding a script that will calculate a running date column that is calculated based upon criteria that is entered into specific cells. I am able to write basic code that can do this. I am running into trouble when the previous calculations have meet its criteria...