dates

Hi I have a counter with a minimum value of 17. As long as this value is not reached, then extra dates should be added to an array of dates. The extra dates should be workdays: if for example 2 extra dates are needed to reach the 17 value, but the 24th of December is not a workday, yet 23rd and...

Hi everyone. First post here, so please let me know if anything is not according to the guidelines. This is a snippet from a table in which data is collected from the brewery I work at (not all columns are depicted): batch # tank numberbrew dateempty...

= Table.AddColumn(Source, "Custom", each {Date.From(Date.StartOfMonth)..(Date.EndOfMonth)}) I am trying to create a custom column but I keep getting this error:

Hi all, I found formulas to calculate the fiscal year, but I'm trying to figure out a dynamic formula that will calculate if a date is within the current fiscal year (fiscal year for me starts in August). For example, I would like the result to show the following for these dates...

Hi I have a reference cell B2 which contains the year. I would like to create a formula that contains dates (not referenced in cells) and counts the duplicate dates. Within the formula I have the fixed dates DATE(YEAR(B2),1,1),DATE(YEAR(B2),3,2),DATE(YEAR(B2),5,1),DATE(YEAR(B2),5,9) and I would...

Hi, I am looking for one Excel formula to put in cell A1 that counts all AD values on workdays (not weekends nor holiday 2-01) from the beginning to the end of the month. The dates (see image) are in row 2, the values in row 3. I am struggling with this.

Hello, I am looking to have a column of dates (column G) fill GREEN based off the conditions: 1. If there is a "P" (stands for portables) in column F 2. If the date listed in column G is over one year old (365 days+) I am also looking to have the same column of dates (column G) turn GREEN...

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

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

Good morning, I need the help to solve a problem. I need to search one text in a table with a range of date: Supplier Date Value A 19/10/2022 Madrid A 05/10/2022 Barcelona B 17/10/2022 Zaragoza B 09/10/2022...

I need to identify whether two dates (Start and End) fall within any months from 01 April 2021 to 30 September 2022 Some of the End Dates are blank which shows that particular record is still active. Example Just a small look into the columns. Apologies, don't know how to increase the number...

Okay, the table below is an example of what I need but not sure how to write the formula/what setup would be best. I am trying to figure out the best way to make the status column work correctly. For each row: if Date 1 is 1 day or less before Date 2 = Red Status if Date 1 is between 2 day and...

Version: Excel Online I want an average of the time (in days) between two milestones for many different people (one person per row), but I want the formula to ignore that row if there isn't a date in BOTH date cells, since it throws off the average in a major way. Example "TABLE_1" EE Name...

Hi Everyone! What I am trying to do is link start and end dates from one work book into another, but not the exact cell position where the date currently is. I can do the first part easily enough by putting "=" in the cell of my current work book, and then selecting the date cell from my...

Hello Excel Gurus! First time poster here :) I am trying to set up a spreadsheet for a psychiatric provider to use to track when clients need to be seen. Ideally, I would like it to be the last name, first name, frequency, last seen date, needs to be seen date. I know how to do the basic last...

Hi Everyone! (Sorry this is so dense) I am trying to find a way to use conditional formatting to override my existing conditional formatting, while still retaining it underneath. I want to do this by having the conditional format recognize when I have input a date manually VS. our...

Hi, so I have this problem: I want to be able to download url folders based on the start date (dtReportDateStart) and end date (dtReportDateEnd). So I want start date, what's in between and end date. My code: Sub Get_XY() Dim dtReportDateStart As String Dim dtReportDateEnd As String...

I have a set of data in which two columns define a start date and end date - I'll call it my Census data. I have another dataset, call it my Day of Month data with one column that has individual dates of a month, i.e. 7/1/22, 7/2/22....7/31/22. In the range of start dates and end dates in my...

Hi, Still beginner here. I've been trying to find the way with Google, but there are too many different response and none have worked for me so far. I need to save a file with this name(based on today being August 2022) to my desktop: "2022-07-01 to 2022-07-31 Consolidated file.xlsx" "The first...

Hello I'll try and keep this simple. Sheet 1 This is a list of absence. Each separate occasion of absence is recorded against a unique employee ID in Column A and on it's own row. On each occasion, there is an absence start date and an absence end date. Example: an employee with 2 separate...