days

Hi All, I have a loan repayment schedule as below where interest accrued on loan principal is capitalized on quarterly basis (blue marked dates) and payment is made monthly. Here green cells are variable, meaning user should be able to define loan disbursement date (here, 7 OCT 2019), first...

I've been trying to create a formula with multiple criteria, and I can't do it. If there is any number in column C, then I need to look at the dates in two columns (J and AB). If either J or AB has a date more than 28 days ago (based on today), I need it to count how many students have no call...

Guys, I am trying to make a spread sheet that keeps track of what I eat, when I do it and the average time between meals. I tried Excel since I'm assuming it's doable but of course, to do it, one must be able to explain it to others when one's asking for help. The actual span of a day is...

Hello! I require a bit of help creating a formula for my attendance spreadsheet. We implemented a policy that states "if you have too many infractions, you will go on probation for 30 days, AS LONG as you don't have any infractions during those 30 days. If you do, however, the count starts back...

Hey Guys, Looking for some help here - I havent been able to find a solution anywhere. I have a matrix table that provides a view of aging inventory. For each client they have a number of days to work the ticket before it is outside of SLA. I want to add a column that shows when those...

Hi, What is the best way to sum the below values up to get a total? D2: 21 days 17 hours 44 minutes D3: 13 days 01 hours 43 minutes D4: 22 days 02 hours 30 minutes The format of these cells are d "days" hh "hours" mm "minutes" Thanks.

So i'm having a little difficulty working out how to get an average formula to work in regards to days, months & years. I have a spreadsheet which will track employee absence and i would like to be able to see the average duration for absenteeism across all employees. See below for an example...

How do I calculate the remaining number of work days left? Based on today's date and an end date?

I could use some help with how to write this formula in ACCESS to determine age bucket for the column DaysAged. It works fine when I input just the formula for <= 30 days but, when I add 30-60, 60-240, and > 240 it isn't calculating correctly. I'm just not sure how to show the days between 30-...

Hi There I have created the attached planner/job board and require help in doing the following. 1. Under the days of the week. if a date range is entered i want it to auto colour the cells under days of the week. 2. in the engineer list section if i set and engineer to on holiday or sick, i...

Is there a way to calculate the number of work days between two days? If so, how? Very new to Power Query...….

I have a spreadsheet with 2 separate sheets set up as follows List Department Shift State Home Health Nights Toys Nights Toys Days Sporting Goods Days Grocery Days Toys Nights Furniture Days Pets Nights The goal of this is to look at the summary sheet below and...

I have to extract the left most amount and the number of days from the below attached text string and perform mathematical operations depending on the number of days. <colgroup><col></colgroup><tbody> Condition $280 for days 1 through 6...

I have moved past the issue of time to decimal, as that was handled quite efficiently here. I am now on to a new "I need help" thing. I would like to have a yes or no question box pop up upon opening the worksheet (or workbook or speadsheet, not quite sure of that terminology yet) which changes...

I have a basic spreadsheet where staff enter details of events they're planning, it's in a set format so the date of event goes in a specific row. Even with only 4 events per month there's an issue with people not checking and trying to schedule them too close together. I've been asked to...

Dear Sir, I have a problem I want a formula for the problem Problem is: In a cell I have number of days (the days btw 2 dates) Keeping that as reference: I have 3 slabs: slab 1 : if the days are more than 5 and less than or equal 10 the number of days should display in a cell next to the slab...

Good morning excelites, I need help with a formula to average data for a given day based on the data below. I need to first identify what day of the month (Mon, Tue etc) a day number falls on in any given month and then average those days out. For example, in the table below "Day of Month" in...

Hi there, I have a formula that calculates the KPI days from the date deemed adequate. =IFERROR(WORKDAY([@[Date Allocated or Adequate]],[@[DPE KPI(working days)]],Holidays),"")............ returning the DPE KPI Target Date. If the KPI working days (returned from a vlookup) happen to be zero I...

I am working on an employee attendance spreadsheet that is based on a point system. Point values are associated with different absence reasons and tracked on a rolling 12-month calendar. I was able to successfully complete a spreadsheet to take care of this part. However, I am unable to figure...

I'm trying to calculate the date/time difference between two cells, to be displayed in days, hours and minutes. Right now, if I simply use <code><code>=A1-B1</code></code> The cell displaying the difference has the following custom formatting: <code><code>d "days" h "hours" m...