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

    Sales from days of this month vs same quantity of days same month last year.

    Hello, first of all thanks for your help. What I want to do is to compare the cumulative sales from working days since first of the month to current date vs the sales of the same quantity of working days same month last year. Lets say today is September 4, 2019 and we work from Monday to...
  3. R

    Changing Font Type in Header VBA Code

    Hello Everyone, I'm getting some odd behavior when I try running some VBA code that updates the font type in a page header. Here is the snippet of code: With masterWkbk.Worksheets("Dashboard") .PageSetup.RightHeader = "&""Times New Roman,Regular" & Format(Now, "YYYY") & " " & prevQtr &...
  4. K

    Need help to copy a call value in all rows of a dynamic sized table

    Hello, I started learning VBA yesterday,.. please bear with me if this is v basic,.... I have a set of data in a worksheet that will vary in size. i would like to copy the value in cell P2 (10.10.2019) down to the bottom of the column,.. which is currently 4000 rows long. <tbody> Column P...
  5. gheyman

    Access: Date in an unbound field on a form

    I want to add a field on my form that will act as a "Title". Actually I have 6 fields. In the first one, if todays date is in the month of September I want it to say "September" in the field. I would even be OK with the Month and Year (But not the day). In the next box if today is 9/17/2019...
  6. tyija1995

    Date Question

    Hi all, Hopefully a simple solution to this question, I want to basically return the date of the Friday just passed in "ddmmyyyy" format, so a formula to return 19072019 in the example of today's date. If the date were Thu 12th September I'd want 06092019 - if the date is a Friday then stay as...
  7. 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]...
  8. 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...
  9. 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...
  10. 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...
  11. N

    highlighted specific dates based on today's date

    I have a list of dates in column A and need to identify (probably by conditional formatting?) which dates occur between the last but one 21st of the month and the last 20th. Thus if today's date is the 21st September, entries in the list between 21st August and 20th September should be...
  12. D

    month datevalue language issue

    Hi all, I have a column with month names in English (January, February, etc) and I wanted to transform them into months (and in the end in a complete date based on month-end) with this formula: =MONTH(DATEVALUE(C2&" 1")) However my regional language is not in English, but the months are. So...
  13. Neffy

    Formula Assistance

    Hello, I need some help regarding formula-ing this. It goes something like this ! Hopefully i made sense, if not, let me know and i'll attempt to clarify it. Table 1 <tbody> Date Department Seconds Purchased etc etc 18 July 2018 Home 500 1 as fs 19 August 2018 Phone 100 2 asf sf 19...
  14. P

    Counting dates in September in a range and

    I have 6 dates in a medium dare format and am trying to count the number of dates in September by using month = 9 and then adding it to if they gave been paid “No. Was thinking of doing some code below =if(month($A$2:$A$7)=9”,1,0) However am getting a value error Anyone got any ideas
  15. L

    Start Week 1 From September 2nd 2018 VBA

    Hi, How can I create a function that looks at a date in a cell and returns the week number? But the week number isn't starting from 1st Jan but actually for this year 2018, it's August 27th which is a 53 week year. For 2019 it's September 2nd. Thanks,
  16. T

    formula to give me year to date up to end of last month?

    Hi Everyone, Ok so I have a problem, I need to calculate last year year to date figure. I have the data set out in columns <colgroup><col><col></colgroup><tbody> March 2018 ,G April 2018 ,J May 2018, M June 2018 ,P July 2018 ,S August 2018 ,V September 2018, Y October 2018...
  17. W

    Unable to get Sort to treat week days and months as TEXT string and not a date

    I have an Excel column with song titles in it. When I do a Pivot table and sort the data by the songs it keeps putting the song titles "Saturday" and "September" at the top with the numbers instead of down in the "S"s. I am assuming it is treating these as numbers instead of text like September...
  18. A


    Dear friends, I want to use weeknum function for the entries from 1st of September. But I want the entries, starting from 1st of September as Week 1. Where as the function returns the week number 35. So my query is, can we have customized weeknum ? I mean, can I start 1st Of September as Week...
  19. F

    Highlighting a Column with Conditional Formatting Based on Entered Date

    I am working on an Excel spreadsheet where the user can enter a date in A4 (Ex. September 2017). My column titles have abbreviated months (Ex. Jan, Feb, Mar, etc.) and begin from B7:M7. What I would like to do is have a column highlighted with conditional formatting when the text in A4 equals...
  20. D

    Lookup formula that omits duplicates

    Hi all. I have a large data set where I am trying to determine which people worked on specific days. However, there are some instances where multiple people worked on the same day, so I am getting a double count; I only want to count it once. I have 1000 rows of data and I've provided some...

Some videos you may like

This Week's Hot Topics