# days

1. ### pulling data from tables based on criteria

Hello, I have a workbook which contains a several different tabs all with a different persons stats. i was entering this manually but now i have managed to do an sql dump from the server with all the data i need. i have created a tab called data dump where im going to copy and paste this from...
2. ### Sum text that contains numbers - But ONLY the numbers.

Hi all, I am trying to do a planning schedule, which includes different earnings, such as; sick days, holiday earned, lieue days earned/taken, compensation earned/taken. The hoiday earned, and sick days were very simple because all I did was color code "H" for Holiday, and to the very right had...
3. ### Breaking down electricity usage per day/average over month span

Hello, I am trying to create a spreadsheet that will break down my average electricity costs by day to help me better estimate accruals for invoices I haven't yet received. My columns are: Invoice Payment - (1/1/2019 - 2/4/2019, for instance) Average Rate/Day (By Invoice) - (The invoice...
4. ### Excel Date greater than another date

Hello everyone - I'm trying to input an If statement that says if date XXX PLUS 30 days is greater than date YYY, if true say "good", if false "Not good") For example cell A1 = 12/3/18 cell B1 = 12/15/18 So if cell B1 Plus 30 days (1/15/19) is greater than cell A1.....
5. ### Subtracting dates for days of rest for a player

I have an ongoing database with multiple players. I need a formula to sort days of rest in between games (Column C) without sorting the players. I can get this to work if I sort the player ascending, but this causes extra work with the daily feed. I was wondering if there was a way to do this...
6. ### Something in this code is causing my workbook to freeze...

Hi I am 100% certain that something in the below code is causing my worksheet to hang when I double click on a cell or when I run a macro affecting this sheet - there are NO VBA errors. Unfortunately the code was written for me around 15 years ago, so I can't go back to the author to query it...
7. ### How many days in each month

Context: We have a check in date and a check out date. In order to reconcile every month, we need to see how many days for each booking get accounted to every month. So if a booking starts on jan 15 and end on Feb 4, we need to be able to report the 17 days booked in Jan and the 3 nights if...
8. ### Summing an array based on cell number that can be a decimal

Hi all, I have had a good look round the forums and still can't find what I am looking for. (Probably because I am not searching for the right thing!!) I am hoping the below can be dealt with using a new function, but open to all ideas. I am trying to build a forecasting tool for predicting...
9. ### Looking for If Formula

Hello Everyone, I have the following table <tbody> Column A Column B No. of Days Value </tbody> I am looking for a formula in "Column B" which would return the value as per below condition. <tbody> Count Of Days Value 1 0 2 0 3 0 4 1 5 1 6 1 7 1 8 2 9 2 10 2 11...
10. ### Help me develop this formula?

Hi all I have the following formula which is working great (as far as it goes): =IF(AF6>AA6,"Not due yet",IF(AF6>AA6+7,"~ 7 days late","+ 7 days late")) AF6 is Last Review Date AA6 is todays date. So the formula is looking to show: If the Last Review date is overdue return one of the messages...
11. ### counting unique instances in data set meeting multiple criteria

I need a formula that will be able to count the number of days that a persons name appears in a large data set within a defined date range. The issue I am having is that the persons name will likely have multiple entries on the same day, and i only want to count the first instance. Any help is...
12. ### Calculating Good Conduct Allowance for inmates

Hi, I have a slight problem, I have an excel doc where I need to calculate an inmates Good Conduct Time Allowance between some dates (GCTA) If that was all I already managed to do it but... There are some caveats in Oct 2013 the rules changes and the GCTA amount changed. I did all of this...
13. ### Dates minus time periods

I want to create a spreadsheet that has a column with a date eg 04/02/2019 then another column that has a time period, eg 3 years & 10 months & 3 days. I want another column with the result of the date (04/02/2019) minus the total years, months & days = another date which is 3 years & 10 months...
14. ### information provided by dates

ill try to keep this simple. basically i have a start date and an end date of an employee. the first thing i want to do is work out how many days a person has worked over a quarter. so i need something that will work out how many days there are in jan feb and mar and add these together. then do...
15. ### Date Fields

right i need some help with this. I have to work out a pro rata for people based on the amount of days they have worked over a quarter period. I have a start date for them and an end date for them. first off i want to work out how many active days they have worked over the quarter. so from...
16. ### dynamic number of days

Hello everyone, I am trying to make an excel spreadsheet that will do a couple of things. The first is it will tell me how many days have passed since a specific date. For example, if B2 is 1/24/2019, then C2 (which is where I want the number to be) will be a dynamic number that goes up by...
17. ### start date field

anyone have any suggestions for this. so i am including calculations per quarter. so jan - mar apr-jun etc. what i want to do is pro rata people based on their start dates. so if the person started then pro rata this so they dont get full payments. i am waiting for someone to send me a working...
18. ### days remaining

I have date in my F1 like 12/03/2019 dd/mm/yyyy. I want formula in H1 that how much days remaining from currant date of today. Today is 08/03/2019, so answer in H1 should be "4". and tomorrow this H1 should be "3", automatic by formula