date

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

Greetings Excel community, I have a set of ID's and dates which are associated to these ID's. The ID's are repeated but there are numerous dates associated with its respective ID. What I am attempting to accomplish is combining all the dates associated with the specific ID. For example, ID 123...

Good afternoon - I have a task which started on 02/07/23 and is to repeat quarterly always on the seventh day of that month for an indefinite amount of time, how can this be displayed in such a way that the cell always shows when the next quarter is based starting from 02/07/23? The idea is that...

Hi, im no pro at excel and would be grateful for any help in how to make what i need. I have attached an image for reference but what im trying to make is a sheet where for documents named in the top row, we input the date we implemented it, then the cell below indicates the due review date -...

Hi Guys, I have an issue which seems to be easy but it's DAX so it isn't :-) I have similar Table (called "Data") as source: Added Table to data model then inserted a Power Pivot: count values in column "C" per Date and per Country: I started to get proper values for previous date but...

Hello! I am looking to complete a formula that will look for a specific text between columns and rows but only count them if they are between 2 dates. For example, if the text apple is listen between E:N between dates 3/21-3/31 in sheet 1 then deliver a count value in A1 sheet 2. I have tried...

Hi How I can do this ? For example, if I click / choose a date 11/04 in a range D2:J7, it should colorize the same date (and descriptions in 2 near cells) and same color in a range L2:N15 if the same date exist in column L. Is it possible by VBA or Conditional formatting? Thanks

Hello Excel Community, I have a weird request which I am hoping someone might be able to provide a solution. I have rows where dates are provided in the following format yyyy-mm-dd and contain multiple dates in that format (Example: 2023-04-062023-04-072023-04-08). What I am trying to...

I have a piece of VBA (see in full below) that processes data from one sheet and outputs into another. Both spreadsheets are stored in a SharePoint site. The code works absolutely fine on my PC and one member of the team who run it. However, on the other 2 team members PCs an error occurs...

Hello Excel Masters I'm looking for a formula to convert the below text in cell A1 into the date Mar 20 A1 = March 20, 2023 at 10:21AM The formula needs to work for any month and day, for example in 6 months the formula would convert September 21, 2023 at 11:21AM Thank you in advance

I need to figure out how to change the below macro to delete all dates from 1 year ago prior to the month we are currently in. For example, because today is March 17th, the below will delete all rows prior to March 17th 2022, but I want all of March. I want it to delete everything prior to March...