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

I've got multiple payment dates and I want to match them to a time series and populate the cell with the individual payment amounts. Sounds simple use of xmatch and indexing or similar but I'm having a mental block. Any help appreciated

Hi, I had column of dates mm/ dd / yyy , but they were acutally text so used text to columns to convert to dates, fine, but for the order I would have liked the year first, but despite selecting 'date' ' ydm' from drop down I always got the the original order but now as dates? any suggestions...

Hi, I have a VBA code (see below) for a macro button to add month sheets in a workbook. Now the month sheets are sorted from January to December, but I would like them to be sorted from December to January; while still keeping differently named sheets at the end of the worksheet tabs. After...

Hello, I am trying to make a table to input a set of daily data, so I have my dates (using a formula) as the top row, and have applied conditional formatting so that the WEEKEND dates are in blue and have strikethrough text. I would like to carry that formatting down to all the rows beneath each...