date

I'm having an issue where the following xlookup =XLOOKUP(@A:A,PAYE!AC:AC,PAYE!F:F,"",0)&XLOOKUP(@A:A,Contract!W:W,Contract!F:F,"",0) Returns the date as a code and refuses to format into the date format below. I have manually typed the top code into a separate cell and formatted as date and...

Hi, I'd like to plot x axis with dates with non standard interval and then a cumulative total number on the y axis. example data below, so the x axis isn't normally spaced as the number of days/time period between x axis isn't the same, so it's like a jumping graph over time Date CumTotal...

I'm trying to come up with a formula to determine the number of years, months, and days (in this format) when subtracting from a specific value, i.e. 17 Years, 0 Months, 0 Days (this will always be the same and will not change) For example, I need to deduct 15 Years, 5 Months, 25 Days from 17...

Hello, I am trying to come up with a function or a VBA macro that is able to automatically update a cell with the next days date (based off previous worksheet) on the newly copied shoot Example: make a copy of the current worksheet (Sept 8), but the date in cell B1 updates incrementally to Sept...

Im trying to set up a document to show the differences in days between 2 cells = Example: A1 has a planned date, B1 has an Actual, C1 has the difference, i have used =B1-A1 in cell C1 but if cell B1 is empty it is bringing back a number of "45448", why is this? What is the best formula to use?

Hi Team, I am creating a calendar view to show room bookings and have been able to pull through the start and end time of the event, I now just want to show the cells in between as highlighted. As you can see below, the Investor Event starts at 8 and finishes at 17:30, I would like the cells in...

Hi All, Hoping someone has an easy solution to decipher if hours worked by an individual fall into the day shift (0600 - 1800) or night shift (1800 - 0600). The issue I'm having is that if someone has worked across both shifts, I need to be able to split these according to what shift they fit...

When i view my excel file, the dates are in dd/mm/yyyy format. When i click on the date, it changes to mm/dd/yyyy format. When i click on format cell, the format is dd/mm/yyyy. This is causing me trouble as i have built an excel processor app that is not functioning correctly due to this. Why is...

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

Hi, We have a customer with several depots, and each has different fixed days of the week they accept deliveries from us. We tell the transport team what date they should plan the delivery for based on the order date (which is not always the date the order is processed) so we manually...

Hi I am stuck and need some help please. I have attached a picture of the issue i am having. Basically i have 7.5% in the red box (Cell B2) that i have to update manually. I would like it to auto update each Tuesday of the month with the same % as the week before (orange box's) but if say on...

I'm stumped on this one - I'm currently automating a file and I need the macro to select the most recent date slicer dynamically. My current code is selecting all of the dates listed in the slicer instead of the most recent date. Sub maxdateslicer() Sheets("FIP").Select...

I am attempting to get absentee points to fall off after 365 days. My sheet has a row with the date. A row with the points. I have it totaling the points in the row but want the points to not be included if its been 365 days. My formula does not work...I have attempted multiple variations with...

I am trying to figure out formulas to create conditional formatting for dates that take into account the current date and its relation to future dates, and that are not limited to specific months, years, or number of days. I would like these formulas to be able to carry over into future years...

dear all, I'm currently stuck with Excel and I hope you guys can help me. I am looking to lock specific rows (in the screenshot: the forecast quantity) D6-O6, D9-O9, D12-O12, D15-O15, etc (until D24-O24) after a specific date has passed. This date will be defined in D3-O6. So the way it...

Hello, I'm facing the following problem: I insert in 2 cells: month (in text) and year (in number) (example. "October" and "2024"). I want to create a function that convert this information in the following format "dd/mm/yyyy" and print it into a specific cell. I tried myself for a lot of time...

Hi to all of you, I have an excel sheet with an Inputbox, where i'm asker to put the number of the month, the year and a third value. Problem is, it was working as intended during 2023, but now, it's swaping the month for the day. I'm in Europe, we use dd/mm/yyyy and I'm trying to make the...

Hi, I have dates with 14 days difference between them (employees paid every 2 weeks). Is there a way to automate the Working days and week days to the end of month from the last pay date. I am currently doing this manually using calendar which is open to errors and time consuming. Basically...

I'm stumped. I have a column B which has dates in the format "Wednesday, March 15, 2023". I'd like the cells in column C to show a date like that as "Wednesday, March 15th, 2023"

I give up! I've been trying to convert a date, say A2 as Saturday, March 16th, 2024 in a text format, to an actual date in the format of MM/DD/YY? P.S. Better yet, how to convert date in two cells, say B2 and C2 containing the month, i.e. 3 in the example above, and 16 also in the example above?