startdate

  1. S

    Error: We Cannot Convert a value of Type Function to Type list

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

    Application-defined or object-defined error

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

    Count Number of weekends excluding 2nd and 4th Saturday

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

    Unit count between Start- & EndDates

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

    VBA DateAdd Outputs Wrong Format

    '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...
  6. C

    Filtering by moving date across multiple columns

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

    VBA code variable keeps reverting to MMDDYYYY

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

    VBA Help for PivotTable Filter Update

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

    VBA Sumifs

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

    Method HasTitle of object chart failed

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

    Charts in VBA

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

    Object Required in Find statement VBA

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

    VBA Copy Paste Range based on Date (Today's date and specific)

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

    VBA copy and paste as values

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

    Filter a Row Field in a PivotTable using xlDateBetween

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

    VBA Question for Range on open ended Columns

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

    VBA filter when search criteria is blank

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

    Date criteria does not appear to be working

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

    VBA date filter,how to add one more filter

    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"...
  20. D

    VBA - copy column widths and formats from one WS to new WB

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

Some videos you may like

This Week's Hot Topics

Top