september

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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,

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

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

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

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

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