oct

I suppose this is more of a math question but I also want to know if I am calculating this right in excel / would be getting the correct numbers. I want to get the average turn around time (time between 2 dates) for the last 30 days. My data is as follows: <tbody> Date 1 Date 2 Difference...

I've been asked to create a tracking template to track every step of the process for formal inquiries that go into a Outlook inbox. The plan right now is to create a system folder for all inquiries, and then in that folder create a subfolder for each day an inquiry comes in, and from who...

I have several files that I use every month. I have two sheets which include the current month that I am working on. For example, I'm starting the November file and I need to rename a couple of these sheets from Sept to Oct (I do commissions so we I am preparing the Oct commissions to be paid...

Hello, I have searched online and in the forum for this answer. Everything I find only references is you have a table, or data within two columns, and you are adding additional rows of data. My scenario is that I have my dates as my headers/labels, and my data name/header is in column A. As...

I'm trying to setup a roster. In Cell K1 I have the date (which changes through drop down box). In column A I have a list of dates which some are the same date, Column C has Team 1 and Column E has Team 2 What I'm needing is when I change the date in Cell K1 it only shows Team A on that date in...

<tbody> 2018-08 1 Aug 18 31 Aug 18 2018-09 1 Sep 18 30 Sep 18 2018-10 1 Oct 18 31 Oct 18 </tbody> Please see table above. If I have a date like 9/15/18, I want it to run a search against this table, then return the corresponding result in col A, ie 2018-09. At the...

Hi, I need some help with a formula. I have a table with values per month and an in stock quantity. Has anyone any idea if you can use a formula to give you the month in which the stock will run out? I.e. ROW 1, the stock will run out in "Oct 19" - is there any calculation that will provide...

I have a sheet with the column headers as dates by month and year. Column A is "Jan 2002", Column B is "Feb 2002" etc until Column HC "May 2019". In Column HG I have a the date of the last time my customer ordered "Aug 2007" for example. For each month there is either a dollar amount or it is...

I have a number of dates in a column. In each case I'd like to see how many months between the dates in that column, and another date, say Oct 31. I don't care about the number of days, just number of months. So if I see a date like May 1, I'd like to see the difference between that and Oct 31...

Hi All, I'm looking for a for a macro or formula that recognises a change in Column A, then at each change, it copies the same row from column B, pastes the value to column C and fills the next months downs until the next change in column A. At the moment I have Column A and B however I want it...

Hello, I need some help with my data with different months across a financial year. I want to pull out ending month data, so where the date changes from one month to another eg. Sept - Oct - different month so pick the ending value shown in the column, else 0. The idea is that I want the...

I have several sheets containing the Month and Year in B4:M4 (Sheet3 to Sheets11) I have set up months and year on sheet "Months" and linked this to Cell A2 using data validation I have written code so that if for eg Oct 2018 is selected from the drop down list, that the column containing...

Hello I have literally rubbed my eyebrows away trying desperately to create a dynamic line chart with columns A, G and H from the below data, so the chart shows only the most recent 90 calendar days entries (NOT the last 90 entries - please let me know if it's necessary to insert a daily entry...

Dear All, The attached excel sheet have date value in different cells , But excel won't recognise as date , So i want all cells date value recognise as a date value in (mm/dd/yyyy) format. While applying formula on cell values it won't recognise as a date value. Oct 1,2018, 2:05 PM Oct 1...

I have kept a personal exercise log for many years and I am trying to keep myself motivated (extract below). Column A12 contains consecutive dates exercised from 01.01.1999, and a row is added to this for every new day. Column B12 contains exercise activity. Mon, 8 Oct 2018 OTHER Tue, 9 Oct...

Good day! I am creating a Shared Workbook and need to create a dynamic table based off of the CurUser (defined name). Want to know if this is possible. Table1 (Dynamic) <TBODY> ID # Correspondence Name Submitted By Submitted On Due Date Last Action Taken (LAT) LAT By...

I would like to create a worksheet that includes pulls data for each fund, but one fund (i.e. AA Fund) at a time and for Net Purchases for fund total ($6,678.00 as of Oct 1, 2018). I would like to create a table that shows the time series. For example, column A should be the date, 10/01/2018...

Hi Everyone, I am hoping someone can help me out on this one. I have a table similar to below, only larger. Headers are dates usually 6 months or so, but each column is a week. The rows are items. This table is on one worksheet. On a separate sheet I want to have a dynamic monthly total sheet...

Not sure how to construct a formula to check for between date ranges for any year, not just this year. I need to return a specific value if today's date is on or after Oct 1, but before Jan 1, and a separate value if not. Any help is appreciated.

Hello! I've been trying to figure out how to rename multiple sheet names for all of today.... I've never done Macros or anything like that before and I've been trying to but nothing is working the way I want to. I'm in charge of creating schedules for work and each day is a different sheet and...