dates

Hi Is there a way in power bi to calculate the Monday's covered between two dates, if annual leave or sickness cover more than 1 week? I have also asked if it is possible in Excel, but then Power Bi, came to mind as well. Thanks for any advice. ABCDEFGHIJK1Absence CategoryAbsence Start...

Good Morning, I have a set of data with start/end dates which I am trying to split into hour categories so I can dissect further (i.e if a line starts at 5am and ends at 7am I would expect to see 1 hour in the 5 and 6 am columns) My formula splits things up nicely but when the end date falls in...

I would have sworn that I had already asked and had wonderfully answered, but I can't locate it so, I'll ask again. Is there an equation to yield the 2nd Wednesday of every month based on the cell/month above it? I.e. I know that I can't click and drag my way to answer. It's probably...

Hello In column A I input a date In column B there is a text column where users select from a dropdown either 'Priority' or 'Normal' In column C there is a formula: =IF(B2 = "Priority", A2 + 5, A2 +28) Column C is formatted as a date. I have copied the formula input in column C down the...

hi, i have a dates table. (eg. below). I would like to use a query to filter only the last date for the Financial Year ending March 31, and the latest date available. (i.e the yellow shaded ones in table below). would appreciate any help here. thanks in advance.

Large dataset with varying Start and End Dates. The Week Numbers need to fall in financial year (01/04/2023 - 31/03/2023). 01/04/2023 needs to be Week 1, 10/04/2023 is Week 2 and so forth with possible carry over into the new year. Using the Start and End Date, allocate the weekly cost to the...

I know this seems simple but I've been researching this for a few hours and I'm come up blank. I'm looking to do the following two things with conditional formatting. I need a cell in Row B to go RED if the planned end date has passed and YELLOW if the planned end date is within 14 days of the...

Greetings Excel Community, I have a set of data and i am wondering if there is code or formula that can be created to parse these values into comma delimited dates. The dates are combined together to make it look as a long string, however i am attempting to create the end result under the...

Hi, how would I clear the cell contents which are formatted as dates in a column if the dates do not fall in between 17:00 from yesterday to 17:00 on the current day? Using VBA. Thank you in advance!

Hey all, Thanks for taking the time to review my question. I must be missing something simple but for whatever reason I am missing something. In "Tab A" I have a list of "A" names, "B" dates and "C" total hours, In "Tab B" I have "A9:A39" each date of the selected month, "A1" the name I want to...

I have an excel where I need to pull in the total hours for a date range (always start on Monday) in my excel tab called 'Dashboard'. I'll be getting the data from the tab 'Budget' but I only want to pull in the number based on the QuickBooks Code I've identified on B1. So AH3 will equal to...

Hi all, I am wondering if someone is able to help me out to create a visual that would look like this below (I found a topic somewhere else with same request I need today. couldn't find answers about it so I come here to check if there's luck Power BI Stacked Bar as Timeline with Milestones)...

I am still a newbie to most Excel functions. I have created a workbook with IF Statements, VLOOKUPs, Concatenates, and VBA Codes. However, due to an annual rate increase, I need to create a complex IF Statement for just this month and I can't quite wrap my head around how to do it. Currently...

Here is the problem: I have a required complete date of 5/31/2023 (LINE 15) but I was not able to complete that until 6/6/2023 I would like a count of how many projects missed the deadline. ABCD1SubmitComplete ByAct. Complete DateDAYS...

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

Hello - I am trying to loop 17 textboxes after a user needs to edit the record and update the Due Date in txtDueDate1. The screen shot below shows some textboxes in grey because they are default values when the userform is launched. I read many threads and watch videos on looping through...

Hi, This is my first VBA project and I am preparing some sort of timesheet to be used in my workplace. By extensive research, time committed and effort, I managed to do lots of things in my excel file such as only allowing data entry to "database" sheet via Userform, distinguish users by...

Hi, I have a table in the following format: DateInserted IdentityNumber TeamName MMYY 21/12/2022 0101040504 Team A Dec-22 10/05/2022 0101590849 Team A May-22 07/06/2022 0101632916 Team A Jun-22 06/06/2022 0101750412 Team Z Jun-22 25/10/2022 0101770383 Team B Oct-22 22/12/2022...

I am trying to organise an on call roster where an individual is selected for a seven day period. This is in a table with name - start date - end date of when they are 'on call'. In a second sheet, I want a second table where people input the dates they are unavailable to be on call due to...

Hi everyone, I'm trying to count the amount of times 2 different cells have the same date and also the times in a 3rd cell need to match and the 4th cell need to be before/after a certain time. In my formula I've only managed to put in the times, so if the date is incorrect it will be counted...