date add

  1. T

    add date once a certain product reaches a certain volume of sales

    Hi guys, I have faced a problem I hope you can help me with :) I need to track on which date does a certain product reached a certain volume of sales: 500 units, 1000 units, 2000 units <tbody> Product Volume reached 500 2000 etc A 100 date date B 500 date date C...
  2. J

    Automatically updating date when spreadsheet updated?

    I'm working on a spreadsheet that has a cell for "Last Updated" (B5) - How can I get this to automatically update with the date when any of the other cells (C4:BH21) are changed? I don't want it to update just on opening/saving, only when physical data has changed. Any help really...
  3. V

    How to start a macro when a date is inserted into a cell

    I am new to visual basic, but I need to have a macro runafter a date is added to a specific cell(G7). I don’t want to use a button I would like it to be automatic. Anyhelp would be greatly appreciated.
  4. RJSIGKITS

    Adding a fixed date after clicking a VBA button

    Hey guys. I have a sheet which is a new customer data sheet for capturing new client leads. It has a button control (named 'Save Client') to save the document which has all sorts of VBA code attached to it to create directories etc for the new client, and I need the sheet to record the date...
  5. D

    Adding row in excel through User Form

    Hello Everyone, I've written the following code, but I keep receiving a "Runtime error '91': Object variable or With block variable not set". I've bolded and italicized the portion of the code that is highlighted by the debugger. I'm not sure what's going on, because I believe I've ended the...
  6. K

    Creating a table with months and years given a start date

    Hi, this is the first of a series of challenges I have with excel. I would like to have the user of my spreadsheet enter a date. I would then use that date to populate a number of cells based on the length of the contract (also added by the user). The first cell should show the month from the...
  7. J

    Summing between 2 date ranges

    Hi, I was wondering if there was an easier way of adding between 2 date ranges. At the moment I am using the sumifs function, but this only works to add up from 1 column and what i need to do is sum up from about 10 column between a date range, see example below; A B C D...
  8. S

    VBA Filter - Between Today's date + and - Days

    I've got a date attribute in "dd\mm\yyyy" format in a sheet and I'm trying write a macro, which filters plus minus 7 days from TODAYS date. For example If today's date is 14/06/2016 my filter range will be 07/06/2016 to 21/06/2016. I specifically need help with adding and subtracting from...
  9. F

    Max date

    Hi I have source data into sheet1 like: <tbody> ColumnA ColumnB Audi 01/01/2015 Audi 30/03/2015 Bmw 06/06/2015 Audi 15/07/2015 Bmw 02/02/2015 </tbody> Into sheet2 I have unique list of values from columnA: <tbody> ColumnA ColumnB Audi 15/07/2015 Bmw 06/06/2015 </tbody> How to...
  10. K

    Userform will not return desired date format into textboxes

    Hi Experts I have been through so many potential breakthroughs in the past week via the net/forums/handbooks etc but cannot for the life of me find the exact code needed to return "dd/mm"yyyy" to my textboxes when i intend on updating exsiting data within my form. Basically I have a textbox...
  11. S

    File not saving correctly after running macro

    Hi Everyone, Hope you're well :) I have a macro that I am running trying to save an attachment into a specific folder. Its working well except for one part. 'examine each attachment in folder - only saves emails with excel attachments If SubFolder.Items.Count > 0 Then For Each Item In...
  12. R

    Macro to add date when you double click a cell in a specific range

    Hi, I'm trying to figure out how to write a macro that will add date to a cell if you double click it. But this feature should only apply to a range of cells $C4:$E1000. The date should not change the next day when the file is opened
  13. W

    Date function

    My date (J4) is 1/15/2014 If billing frequency (H4) is 1, I want formula to add 1 year, every year to 1/15/2014 If billing frequency (H4) is 2, I want formula to add 6 months, every 6 months to 1/15/2014 If billing frequency (H4) is 4, I want formula to add 3 months, every 3 months to 1/15/2014...
  14. T

    Cell Range last modified formula/macro

    Hi, I'm looking for a macro or formula to use so that each time data in each individual row is modified on the spreadsheet, it records the date it was last modified in column J for each row/ I've tried various macros but am also slightly unsure of how to use them. I'm using Excel 2013, if...
  15. M

    Prior Month and Current Month Sales

    Please tell me what I'm doing wrong with this DAX formula. I'm trying to create a report that will include current month and previous month by territory. Unfortunately, i'm getting the same values for both months. PriorMonth=CALCULATE([Sum of TotalDue]),DATEADD(Table1[Date],<wbr>-1,month))...
  16. V

    Get previous days date using VBA Macros

    Hiii, I am having a small problem. Suppose i have a date given as "31-Dec-2013" in a Cell in Excel Sheet and some numerical value given as 4. Then i would like to get the date 4 days back of the given date. How can i get that using VBA Macros??? Ex: If given date is "31-Dec-2013" and number...
  17. D

    Enter multiple dates at once

    Hi, so I am working on a mac on sheets created on a windows. I need to sort by date, but since all the dates appear like 05/12/2010 (on the left side of the cell) they sort by the first number (the month) instead of the year. To fix this I must edit each cell and hit enter so the date appears...
  18. J

    Adding one day to a date, in a loop, until reaching the end date of the Month.

    Hi All. Usually I'm able to review others' previous questions and patch together a useable Macro. Today, however, is a different story. I have a beginning date that I'm finding via the following (search for the first blank cell in the column, then set over one column to the left to find the...
  19. K

    Dates by day of week of the month

    So I'm trying to figure out the code to simply display the number of the day for the Second Tuesday of the month, but have been unsuccessful thus far in my forum search. I know this is possible in outlook, but creating a self generating email in outlook is a PAIN so I'm using excel to generate...
  20. J

    Help with dates in VB code please

    Hello all, I am currently working on the below coding: Private Sub CommandButton1_Click() Dim LR As Long, i As Long Sheets("Sheet2").UsedRange.ClearContents LR = Range("F" & Rows.Count).End(xlUp).Row For i = 1 To LR If Not IsError(Range("F" & i)) Then If InStr(LCase(Range("F" &...

Some videos you may like

This Week's Hot Topics

Top