period

Hi Is it possible to make slicer for 12 hour period from 6am to 6pm and 6pm to 6am? If so how would I do this Any help would be greatly appreciated Thank you Craig

Hello! I have a series of timesheets I've made in Excel. Each worksheet contains a two-week pay period, with the dates in cells D3 through D16 (ie, 14 days). To make the next pay period sheet I've just been making a copy of the last worksheet and then manually changing the dates (well...

I have a formula, found elsewhere, that counts the totals of cells from current date – backwards for one year =SUMIFS($L$5:$BDQ$5,$L$3:$BDQ$3,"<="&F37,$L$3:$BDQ$3,">="&DATE(YEAR(F37)-1,MONTH(F37),DAY(F37))) Data in $L$5:$BDQ$5 Dates in ,$L$3:$BDQ$3 Todays date in $F$37 This works perfect for...

Hi there! I'm very new to excel, and I'm hoping someone could provide the spreadsheet formula which will calculate the below pro rata for each person: I require a spreadsheet to calculate the total bill amount ($336.70) split between six people. I'm using day rates between a bill period of 174...

I am trying to make a list of all suppliers my company has used this month. I want the pivot table to show the rolling 12 month period of the information, but only show the suppliers that have a value for the current month. Currently it will only show this current month of data and not the full...

Hi, I have monthly sales data for two products arranged as follows: Column A: Consecutive month-end dates (e.g. 31/12/2018, 31/01/2019, 28/02/2019 etc) Column B: Monthly sales values for Product A Column C: Monthly sales values for Product B I would like to create a formula that will...

There has to be a better, more concise formula than this. I have revenue, and I want to compute favorability between a new period and an old period. Higher revenue in the new period than the old period is good, less is bad. The % increase or decrease should follow suit. If the old period had...

Our truck drivers are not allowed to work more than eight 12-hour days during a 30 day period, is there a way to track this?

Hello, I have a pivot table (created by someone else) that when the value is 500 it shows a period "." instead of the number 500. Has me stumped!

Start Date End Date PF Paid on Day Lease Period Amount Accrue / Prepayment Period 01/11/2015 31/12/2022 1 LDOP 1,332,238 01/02/2019 31/03/2019 14/03/2013 13/03/2023 3 LDOP 325,000 14/03/2019 31/03/2019 03/12/2018 31/12/2023 3 FDOP 127,500 03/03/2019 31/03/2019 01/04/2007 30/03/2022 3 LDOP 45,101...

Start Date End Date PF Paid on Day Lease Period Amount Accrue / Prepayment Period 01/11/2015 31/12/2022 1 LDOP 1,332,238 01/02/2019 31/03/2019 14/03/2013 13/03/2023 3 LDOP 325,000 14/03/2019...

Sorry if my terminology isn't right or misleading. I'm trying to save some time (in the long run), by making some kind of dynamic formula. I've tried a number of things with no success at present. Basically my formula as it stands, goes off to a second sheet called BCWS and returns a value in a...

I have 3 inputs Say product price,loan period and monthly product sales. What I want is if the user changes the loan period I want to populate the table accordingly. I just can't figure out a way. If you think there is better way to show what I am trying to show as a table format I am open to...

Hi, I'm trying to figure out each month what new customers we have. I have a table called tblCustomer what has a date created. I have a table sale with sales dates. I would like to create a measure that will let me know the sales for the period I've selected, how many are new customers. IE I...

Hello. First of all, thank you very much for taking time to review the below case. So I have a data set and I'm attempting to build a formula with IFS and AND to determine the following; New Customers: customers who have never purchased any of the selected products. Returning Customers...

Hello Excel Gurus! I'm trying to find a simple formula to give me the currentquarter between two dates. I have to do quarterly performance evaluations on mypersonnel; however, the traditional fiscal year quarters work for works for thepersonnel I have that have been here since 10/1/2018. For the...

Hi there, I have long list of Dates as shown in column A below. In column B I want to return the Financial Period to which the date relates. The Financial Period is April to March each year, therefore, I have manually input the correct results in cells B2 & B3. Can a formula be written to...

Hi All, I Created a report from a sales data based / listed on week number/year with $ and quantity etc but would like to show the two sales data comparison between two consecutive pre-defined period both under data selection and column labels showing too. Say i would like to show sales...

Hi All, Working on a way to look at total Sales (DEMAND) for a period in the future. In the case below it is the period starting 5 months from now for a total of 3 months of sales. Below is what I have. It seems ok to me but am getting an error that says "a table of multiple values was...

Hi, I have a spreadsheet that has 2 rows and 24 columns (F15:AC16), 1 column per month for a 2 year period. Under the month row I have a balance row with a set of account balances. However, there is only a balance value under 12 months - not always the same months, but always sequential...