startdate

I have been trying to create a function to calculate the number of working days (including holidays). I found instructions on how to create fnNetworkdays but I am getting the following error when I try to use it in a query: Expression.Error: We cannot convert a value of type Function to type...

Dear all; How can I solve this error: Sincerely. "Application-defined or object-defined error" I have two sheets, "SETUP", "RESULTS". Setup contains the information. Sub Mine() Dim out() As Double Dim date_a() As Date Dim dt As Double Dim I, start, n, j As Integer Dim...

Hi Everyone, Here i am trying to count number of weekends that are available in a particular month excluding 2nd and 4th Saturday I have the below code to check all the Saturdays and Sundays that are available between two dates but i need to exclude 2nd and 4th Saturday between those two given...

Hi all, I'm relatively new to Power Bi and I looked at a couple of questions on the forum, but I couldn't find the right answer. I hope some of you could help me. I have a field which included a StartDate and a field with an EndDate. Between those dates, certain units should be built (let's...

'm trying to add one month to a date, formatted like 11/30/2018, using the DateAdd fucntion, but no matter what date is input, the output is 12:00:00AM The ranges for oneCell and twoCell are both in Date formatting in the excel worksheet. The billMonth is not being posted to a cell anywhere, it...

I have a feeling that this isn't complicated, but I'm just not thinking about it correctly. I have a sheet of my tasks, with lots of autofiltering going on via VBA that is working fine. Now, I want to look at two different date columns (LastModified and StartDate) and filter my tasks where...

Hi All I have been getting some code together which looks at a data tab;e and extracts between 2 date ranges. My issue is the data in the rawdata is in DDMMYYYY - when the msgbox pops up and dates are entered the search results revert the dates its searching for to MMDDYYYY. Any ideas on how...

Hi, This should be a fairly easy problem to fix, but I'm trying to update the date filters in a series of pivots using a named range within excel. My code is below and works fine as is, but I'm trying to replace the hardcoded date parameter in the last line with StartDate, which takes a date...

Hello folks, I am stuck with a VBA sumifs code in excel. Basically, I am trying to get a SUMIFS that should retrieve for each date the value in the sum_range greater than the dates range previously input in a third cell. In a normal formula would be: =SUMIFS(SUM_RANGE, CRITERIA_RANGE...

I've been troubleshooting and running this code for a while now with no trouble on the line that is giving an error now. The line below is returning an "method hastitle of object chart failed" error and I'm not sure why? Any ideas what could be causing this? .HasTitle = True within the...

I am having trouble producing charts in VBA. I am having trouble with the portion in the With statement. I was receiving an error "Unable to get the chartobjects property of the worksheet class" on the line: With Worksheets("LowDistCharts").ChartObjects(aa) The properties I would like to add...

I am receiving an object required error on the following line within the context below. The variable StartDate is a Date data type. I would like for RngStart to be a Range value that I can plug in to the line: ActiveChart.SetSourceData Source:=Sheets("ActiveSheet").Range(RngStart, RngEnd) The...

Hi guys, I have the current macro that I patched up together from different sources. It works relatively well but I would like to modify it to make it more convenient. Sub Copy_Range() Dim startdate As Date, enddate As Date Dim rng As Range, destRow As Long Dim shtSrc As...

Hi.. the code below are working fine except that I need to have it in values not in formula. can anyone help..Thanks hereis my code: Private Sub okbut_Click() Dim startdate As Date, enddate As Date Dim rng As Range, destRow As Long Dim shtSrc As Worksheet, shtDest As Worksheet...

Hi all, I have an error with these lines of code: Dim StartDate as Date, EndDate as Date StartDate = InputBox("") EndDate = InputBox("") ActiveSheet.PivotTables("xLabor").PivotField("CSVFile].[Account].[Account]".PivotFilters.Add2 , xlDateBetween, Value1:=StartDate, Value2:=EndDAte...

I used the Macro Recorder to get the basics, added in for Criteria1 and Criteria2... All worked good till I needed to select certain rows and available cells... Here is the code I am using with all the "Failures" for selecting the ranges.. Application.ScreenUpdating = False Dim Startdate...

Hello, i use the following code, which might be long winded but works, I just need to change the criteria , so if range G17 is blank it just returns the results based on C11 and C20. currently it will return "no Matches found" Is there any code to do this? Sheets("cases available...

Hello, i am slowly working through some old code, and while the following does not error, it does not appear to be doing anything.If is part of the criteria needed to copy rows to another worksheet. effectlively it should only be looking for rows equal or less than 20 days from today...

Hi, I have the next VBA code that filtered between two dates. I wander how can I modify it to bring me also the "(blank)" cells that I have ( I need them too). Sub filter_24() Dim StartDate As Date, EndDate As Date StartDate = DateAdd("h", "-16", Date) EndDate = DateAdd("h", "8"...

I'm trying to copy rows from one worksheet to a new worksheet while keeping the formatting (column widths etc..) of the active worksheet. I'm getting a "Run-time error '438': Object doesn't support this property type or method". How can I fix this code to copy the active sheet formats to the new...