october

I am needing assistance with adjusting my combo box to allow the data to update based on the month selected. Currently, it is only pulling data for the day (i.e. if "October" is selected, it is only pulling "10/1/2018") To start, I have a VBA code below. It inputs data from a spreadsheet into...

Hello Forum, Trying to solve a problem in Excel and cannot find the combination of formulas to fix. Been racking my brain and "googling" but to no avail. Wondering if anyone else on the forums here has had a similar challenge. Some background first. There are multiple records keyed to the...

Hi there i have multiple tables all in the below format only much more data about 2000 rows and 200 columns. Column A describes the day for which each following month (column) was priced. I currently have all the data for the peak table and off peak table. I am looking to create the query to...

Using excel 2016 I have dates in columns A and C and values in columns B and D. The datesand their corresponding values are not matched but I only want to compare the values in B and D with their correspoding dates. Is there a formula I can put in the adjacent columns to match the dates with one...

D=July E=August F=September G=October H=November I=December I have this formula: =SUM(D9,G9,I9)/3 in cell R9 In cell T9 I need a formula which states: If R9=D9, July, , If R9=G9, October, , If R9=I9, December, , (the extra space and comma are there purposely so I do not have to use...

Please help me with the simple formula to calculate Months between to dates... For example, I would put May 28, 2018 and October 1, 2018 and have the result be 4.1 or 4.2 months Thanks

Hello folks, really hope you guys can help me out here. I want to set up a formula so that on the specified date, the formula matches the value in the cell next to it and inputs it in another value. For instance, here is an example of what I have. In column F I have unit numbers and they...

Hello I am trying to get Top 5 sales between 2 dates such as : 1st October - 31st October Excel tabs are as follows: Salesperson - Sales - Date John - 15 - 2nd October Mary - 17 - 5th October Steve - 10 - 17th October Michelle - 11 - 23rd October Gary - 22 - 15th October James - 18 - 12th...

I'm putting together Quickbooks reports into one spreadsheet for each group within our church. I'm having the offerings and expenses listed by month at the top of the page. Within the report, it will have "October income" (or whatever month) in column b. I want to have the total $ which is in...

hi All , could you kindly help me on this formula below. what i want to do is to check the G4 month value with todays month +1 month (meaning this should be 11 since we are in October). How can i do it in the formula. the current formula would not work. please help. This is what i thought...

Is there a way for a cell to represent the to date number of work days in a month? For example at my work the only weekend day is Sunday, so on the 20th of October it would be the 17th workday of the month. Thanks!

Hi Team, need to calculate the Quarter for the Fiscal year starting October to September. Please help

Hi, Im very new to VBA but have tried several different amalgamations of things I have read to get the following result without success. Any help would be greatly appreciated! I'm trying to set up a macro, so that on clicking a command button on a user form; which enters the collected data...