# datediff

1. ### DATEDIFF adding day of year number power bi

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) ...
2. ### Calculate Difference Between Dates in Matrix Using Measure

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...
3. ### Amount of Days Between Two Dates But for Alternate Days

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...
5. ### Using DATEDIF in a SUMPRODUCT formula with blank cells

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...
6. ### Date Difference

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?
7. ### DateDiff gives Type mismatch error 13?

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...
8. ### Hide rows based on Datediff

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......
9. ### showing number of days apart from today

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...
10. ### VBA subtracting times using DTPicker

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...
11. ### VBA script doesn't update todays date

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...
12. ### VBA script doesn't update todays date

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...
13. ### DateDiff no longer works with interval parameters

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...
14. ### Wookbook_Open Message Giving Count of Records not Closed for More than Specified Number of Days

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...
15. ### Question on using DateDiff in a query with more than one criteria

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...
16. ### Need help with VBA code in datediff

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...
17. ### DateDiff in VBA

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...
18. ### Counting number of rows where datediff of two columns meet criteria

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...
19. ### User Input Vs Static Value in DateDiff Criteria

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...
20. ### datedif count down before or after today

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

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back