1. R

    distribute recurring expenses over years by matching dates to enter amounts in cells for daily totals

    I have a very large spreadsheet that will show daily expenses for over 2 years. I want to be able to quickly enter regularly recurring expenses and see daily totals. I then plan to add income later and calculate daily cash-flow. I though I had found a suitable formula and everything seemed to...
  2. J

    randbetween date?

    I want to generate random dates between two dates. I used the formula =RANDBETWEEN(DATE(2014,5,6),DATE(2016,4,23)). Then the number 41918 appears in the cell. What am I missing?
  3. R

    Copy, paste, delete row

    Hi everyone I am looking for a macro that will look through columns X, AA & AC which contain dates on sheet1. If any of the dates are more than 30 days old, copy the row and paste it into sheet2 under the last entry. Finally delete the row copied in sheet1. Thanks in advance
  4. N

    Calculating the Difference Between Two Date fields

    Hi All, I'm trying to calculate the difference between two dates. Formula I'm using is IF(MONTH(D2)=MONTH(D3),((YEAR(<wbr style="color: rgb(51, 51, 51);">D3)-YEAR(D2))*12)-12+(12-<wbr style="color: rgb(51, 51, 51);">MONTH(D2))+MONTH(D3)-1+(<wbr style="color: rgb(51, 51...
  5. E

    Calculating dates using option buttons

    I'm trying to create a form that will allow the user to automatically fill in the beginning and ending date as search criteria using option buttons. Example, the user would select option buttons 1) Month To Day or 2) Last Month or 3) Year To Day or 4) Last Year, etc and the dates would populate...
  6. N

    Array Convert Pasted Range to Dates without looping

    I am using this code which works fine: Set copyrng = lo_b1.AutoFilter.Range.SpecialCells(xlCellTypeVisible) copyrng.Copy Destination:=strng arr = strng.CurrentRegion.Offset(1, 0) aRws = Evaluate("Row(1:" & UBound(arr) & ")") arr = Application.Index(arr, aRws, Array(14, 1, 6, 2, 13, 12, 18, 16...
  7. B

    Finding maximum day number in column

    I have a column with dates. Usually it consists of dates only within one month, but very rarely it has also 1st day of the next month. I need to find maximum (latest) day number to use it in many different places in my VBA code. Currently it looks like this: FindLastDay =...
  8. M

    Having trouble formatting dates in a cell

    I have a range of dates that are written as, for example, 20190102 I am trying to format it to show as 1/2/19 and im not having any luck. I've tried the format cells/date and its not changing. Ive copied and pasted the 20190102 into another work book as a value and tried to format it and had...
  9. W

    VBA calculating dates difference

    Hello, I am trying to write some code that will calculate the days between two dates if cell in column "A" is populated. Currently i have this bit (if A is populated, Q(offset 16) should equal the difference between N(offset 13) and P(offset 15): Dim cell As Range For Each cell In...
  10. K

    Creating a list of dates

    Hi guys, Hopefully there is a simple solution to this problem. I would like to create a list of dates in a column based on the results of the data in another column. So, In col A i have a range of dates that are random dates from throughout the year. In col B I have either a 1 or a 0...the 1...
  11. B

    conditional format

    hello excel experts i like to ask you that how we can do the date which occurs more than 1 time and for different dates different colours
  12. A

    Counting Thursdays to find a last date.

    I am computing an end date for the weekly publication of an advertisement. The inputs are the start date and the number of total insertions, while which Thursdays to insert the ad is based on a binary pattern like 00101 which would mean the third and fifth Thursday of the month - every week is...
  13. R

    Count IFS between 2 dates with multiple ranges

    I'm having an issue with my formula. What I want to do is count the number of times a date is in between 2 dates. I have a list of people and days they took off, each day is in a separate cell and each person is one row. I'm trying to string together multiple rows for my range. On another tab I...
  14. J

    Conditional formatting

    I have 2 sets of dates, depart and return dates I would like both cells to change colour when both dates are in the future. So the depart date may have past but the return date is still in the future so would like both cell filled in until both dates have past. Hope this makes sense
  15. D

    Count Consecutive Dates

    So I have a list of products that may show up on a report for consecutive dates. I'd like to count the current consecutive Workdays (Monday -Friday) the product has been on the list and reset the counter once it disappears for 1 day. Thank you in advance. Dean <colgroup><col style="width...
  16. A

    Storing multiple dates in one cell

    I want to preface this by saying that I am VERY much a novice Excel user (using Excel 2016). I am trying to create a client tracking list and one of the columns I have is "Date(s) of service". Every client will have a different number of services dates, which I would like to keep in the same...
  17. T

    Count a row if a specific date falls between two columns of dates

    I have two columns of dates, a start date and an end date. I need a formula to count the number of rows that have a start date before or during a specific month, and rows that have an end date during or after that month. I can't for the life of me figure out how to do this. For example, let's...
  18. I

    DATEDIF when two dates are the same

    Hi I have this formula which i am using to find the number of days difference between from two dates DATEDIF(F5,P5,"D") when the two dates are the same it is coming back with 0, how do i change this formula so when the dates are the same it brings back 1? Thank you
  19. M

    Finding best poker combinations from a table between two dates

    Hi I have a table with poker combinations achieved on different dates. I need to extract the best dates between two given dates on the second table. Not sure if the image of my screenshot is visible on the post . If not, below...
  20. B

    Sorting a sheet with referencing cell in different sheets

    Hi All, I have a work book with 2 sheets Sheet 1 has a bunch of dates Sheet 2 has other info but also has these dates there but are referenced from sheet 1 If I want to sort by a column with all the info in sheet 2 how do I get the referenced dates to follow the row ? Thanks

Some videos you may like

This Week's Hot Topics