datediff

Hi, I'm trying to add the day of the year number in a power bi calendar , and keep seeing the following; DATEDIFF (STARTOFYEAR ('Date' [Date]),'Date' [Date],DAY)+1 I have tried using this and just get errors, "Day of Month", DAY([Date]) , "Day of Week", WEEKDAY([Date] ,2) ...

I have a Matrix visual with the following: Dates (MM DD YYYY) on Columns ApplicationKey on Rows Application Status on Values The Dates (datetime value) column represents the date/datetime the application progressed from one status to another; this could be the same date but minutes or...

Hello All, I hope everyone is keeping healthy & happy! Just a quick question. I have a userform that contains four textboxes; 1x start date, 1x end date, 1x Alternate Day number & 1x result. A user enters a starting and ending date, eg "01/oct/2020" and an end date "04/jan/2021". In the...

RE: Time tracking application, or at least my attempt at one. I need to calculate the total number of hours that a person was present. Very similar to punching a clock. I have two sets of dates/times that are added via a timestamp function. I have two DateDiff functions set up in an array to...

Hello all, I do a lot of work in Excel for my company's home visiting programs, which requires a lot of grant reporting and summaries. I'm trying to create a formula that will make my life easier in that regard. One of the requirements for grant reporting is reporting on how many clients were...

I am sure this can be done, but I am not able to find anything specifically addressing it. Is there a way to create a DateDiff parameter in a query, where is it calculating the days, between current date and a date field within the table the query is built from?

Hey all, I have this neat little macro that runs on every start of a sheet. It's (supposed to be) pretty simple, checking for rows that are older than 180 days and then deleting part of the content of the row. My boss was so happy over this GDPR-compliant macro. :rolleyes: But then a few days...

I need some help combining both. I have two cells where dates are entered, so if the difference between both dates is greater than 6 months then rows 71:73 unhide......

I am updating a table for a production schedule and I want to automatically tell how many days away an order is due from today without looking at the dates and counting. Is there something that can do this while still keeping the date as well? Jan 1, 2018 - 9 Jan 10, 2018 - Today...

Hey all, Another new guy question here. I'm trying to create a UserForm for people to enter information that includes a DTPicker that will be saved in a worksheet. What I'm trying to do is use the values of the DTPicker to get the total time between the two inputs, in total hours. I am trying...

I posted a similiar question earlier, but it was difficult to understand what my exact questions were. So here goes another try: This is my worksheet: Sub Worksheet_Change(ByVal Target As Range) ' Activate the date when I set case as "Active" If Not Application.Intersect(Target...

I want to calculate the number of days until deadline. Column G15:G1000 is set as the deadline date. I have a similiar code in a worksheet_change script, and it works fine. Also, I'm relatively new to the whole "VBA experience", and haven't really used Workbook_Open() before.:) Sub...

Hi all I recently realised a DateDiff calculation error in a workbook I have been using for years and found an error. I checked old copies of the same workbook and found the calculated data to be correct, so I am pretty sure the same formula used to work for me. But then even when I ran the old...

Hi all, I am trying to add a code so that when a user opens his/her workbook he/she gets a message with the number of records opened 30 days or more with a close date. The open date is in column C and the close date is in column AA. I tried the following (which is not working): Private Sub...

Employee Hire & Termination Dates Rick worked from 08/07/13 until 12/07/13 Jane worked from 02/03/14 until 09/03/14 Tom worked from 08/01/14 until 09/01/14 My report needs to reflect the number of weeks each employee worked between specific dates, 08/28/13 through 08/28/14. I know that I...

Hi Guys - I am currently working on a small project , currently using two dates to be entered by user and wants the date difference to in "months". However i am getting the output in "days" not able to figure out the VBA code to handle output in months. My VBA Code - Sub test() Dim DateStr1...

Hi, Having trouble getting the following code to run. Any thoughts ? I'd like to call the function only if a dates exist within any one row of the ranges within columns D or E? Is this possible ? ------------------------------------------------- Sub TimeReg() Dim StartDate As Range Dim EndDate...

I have a range of data and need to summarize some of the data. In the table below is an example of the data. I would like to have a single formula where I can count the number of rows where the end date - start date is < 14 days. I would prefer not to add an additional column for the datediff...

While I have been able to resolve just about everything through the genious guidance of the fine minds on this forum, I just cannot resolve, nor find a solution to this seemingly simple issue: I am trying to allow the user to specify the 'age' of a record to obtain a list of aged loans. I have...

Hi, I have a list of service dates the can be either a future date or a past date? I want to reference the today function and look at the list of dates and tell me how many months have passed between the two dates.i would like it to show say 30 months to go till next service or -30 because it...