1. megera716

    Calculate # of months between two dates

    I know this is such an easy one, but I'm not getting the desired result and there's a lot of complicated formulas out there that are throwing me off! I just want to calculate the difference between month numbers. So April (4) and October (10) is 6. September (9) and October (10) is 1. December...
  2. P

    SUMIFS - Greater than first of month, Less than end of month

    Good morning, I have a sheet (Payments) with the following layout: <tbody> Date Account Amount Rec 26/10/19 Barclays 100 Yes 02/11/19 Barclays 100 Yes </tbody> On a different tab (October 19), I am trying to use a SUMIFS formula to gather all payments that occurred to Barclays in October...
  3. L

    highlight cell according to date difference

    Hello everyone! I' like a cell to be automatically hightlighted when the date in that cell is 15 days older than the day I type in that cell! For example, today is October 21st, and in cell F5 I am typing the date October 1st. I'd like that cell to be highlited (I'm going to use it for the...
  4. D

    if date falls on weekend, roll to Monday

    eg if the maturity date was october 13, i'd want the maturity date to now be october 14 (monday).
  5. C

    Putting data into calendar format

    I have a spreadsheet where a whole team enter data, and it's often not in date order (e.g. Mary enters 15th October, then Sally enters 7th October further down etc). On a separate sheet I would like to automatically list under each month the dates that have been scheduled, but in date order...
  6. R

    want to see if a range doesn't contains any values other than this

    hi, can't figure this out. I want to create a formula that will check all of column A, to see if it contains any values other than "October". So here's an example: Column A October October March October April In the example above, the formula should return ether "Yes"...
  7. L

    mail merge change the format of the date

    Hi I am not sure if this excel or word issue. I have a column in excel which has dates formatted as below. When I mail merge to word, I loss the format and the date will convert to something like that 30/09/20, instead of the format below. Why is that. Thank you so much...
  8. D

    Need help with conditional formating in a calendar

    I want to highlight the days in the calendar that match the days on the event list. Right now I'm using formula: =MATCH(B5,$AC$4:$AC$39,0), it applies to =$B$5:$X$37. The problem is I can only highlight with one color. I want to use different colors for each location. (light green for...
  9. D

    Countifs formula

    Is it possible to make this "Golf Course Count Table" (on the right) without the "Day" cheater column? and just get the info from the "Date" column? <tbody>#DAE7F5[/URL] "] AC AD AE AF AG AH AI AJ AK AL AM AN 3 #548235[/URL] "]Date #548235[/URL] "]Day #548235[/URL] "]Time #548235[/URL]...
  10. DRSteele

    Golf majors; retreive data from Wikipedia articles

    Can someone please help me? I am trying to use PowerQuery to create a table in Excel of all the golf majors. I wish to extract their dates from the Wikipedia articles for each tournament. For example, from this web address https://en.wikipedia.org/wiki/1895_U.S._Open_(golf) I want the...
  11. J

    Convert 8 columns to two columns

    How do you conver the following schedule How do you convert the following 8 column schedule Date Team ID <tbody> September 5 1 2 3 4 5 6 7 8 September 12 6 8 5 7 2 4 1 3 September 19 5 4 1 8 7 3 2 6 September 26 3 6 7...
  12. J

    Convert 8 columns to two columns

    How do you convert the following <colgroup><col><col><col><col><col span="2"><col span="2"><col></colgroup><tbody> September 5 1 2 3 4 5 6 7 8 September 12 6 8 5 7 2 4 1 3 September 19 5 4 1 8 7 3 2 6 September 26 3 6 7 2 1 5 8 4 October 3 7 1 4 6...
  13. I

    Help, confusing cell extraction

    I need the formula to start looking from the top of the column list of revenues and find the first cell that has number data in it, and the second, third, forth and so on, until 60th. This data then needs to be displayed in a horizontal row. Month 1, Month 2, and so on. In this case, it will...
  14. O

    Commissions formula - IF/THEN

    We are trying to create a single column for double checking commissions pays. All the data is on one worksheet The logic would look something like: 'If there are 1-14 lines with the dates of October, then multiply the value in this cell by .01, and if there are 15-19 lines with the dates of...
  15. X

    How to assign week numbers against series of dates?

    Dear All, I do have a huge data base spread across thousands of rows. Out of this data-set, there is one column which contains the dates from October 2018 to December 2018 in a random order. I would like to assign numbers against the days within every month as follows:- October...
  16. W

    Automatic Date Updating

    Hi I'm doing a summary table for the data that I have. See sample below. I was just wondering if there's a way to make the dates change automatically depending on the selected setting (first box) without having to make a really long if statement. For example, the setting now is for September...
  17. D

    Syntax problem

    I have this line of code: .Range("B23").Value = "October " & Range("E18").Value E18 has the current year and I need the range in cell B23 to be October & the following year. It works to get the current year in B23 but I wasn't sure of the syntax to get the following year.
  18. M

    Vlookup by System date

    I have two sheets (A is ) history and (B is) forecast, I am doing Vlookup on sheet C, both sheets (A and B) column A is date and B is value, what I am looking on sheet C the vlookup by today date, for example, if today is 30 October, my vlookup bring all value from Sheet A till 29th October...
  19. J

    VBA compile error

    Get an error message: compile error: method or data member not found at each of the two lines starting with selection Sub Accrual_Provision() Sheets("backing").Activate ActiveCell.FormulaR1C1 = "Accrual October" ActiveCell.FormulaR1C1 = "=+R[-8]C[-1]/9*10" Range("F41").Select...
  20. N

    nested IF/AND/OR/Contains

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col...

Some videos you may like

This Week's Hot Topics