days

Hi Everyone I am pretty good at excel until it comes to layout.. I’m a Treasurer with a local soccer club and we have a snack shack that I am responsible for. I need to create a sheet where I can enter the total number of notes for each denomination but here is the tricky part I need to do it...

I apologize, I really got reamed for my last post (and justifiably so) and I will try to make it right this time as not to waste your time again. I would like to get the number of days between the last two dates in the date column that has the task columns checked (columns C, D, E & etc.)...

I have dates in A6:A41. In column B6:B41 I have some check marks. I am trying to find the days between the last two check marks in column B. There will be blank cells between the check marks. I have googled and googled and can't come up with an answer any where. You have been a big help in...

I have a vacation calendar to create for 2020 and I use NETWORKDAYS to give me number of days that a person needs for vacation. For example, NETWORKDAYS formula applied to a vacation from 9/2-9/6/19 yields 5, which is correct. My problem is that some employees work on the weekends, so applying...

Hi there, I've tried to recreate two tables which I'm working with below: <tbody> Start Date Finish Date Effective Days Total Amount Daily Amount Month Start of Month End of Month Monthly Amount 04/09/2019 22/10/2019 49 1000 20.41 Sep-19 01/09/2019 30/09/2019 ??? 15/09/2019 15/10/2019...

Hi forum, Hoping you guys can assist and resolve this issue I've had for a while. Every month I receive data with three columns. Col1 is hourly segments so a maximum number of rows of 672 for 28 days, 696 for 29 days, 720 for a 30 day month and 744 for a 31 day month. There may occasions...

I have been doing some research but was unable to find exactly what I am trying to achieve. I have been working with VBA frequently but am not quite advanced enough yet to do do this, so I would really appreciate some help! I have a list of customer bookings, with various information and a date...

Hi Guys, I recently got some great advice on here regarding a function I wanted to get working. I added some code to the vb module, referenced it back in the worksheet and all worked great for a couple of days. Im now opening the *xlsm and none of the calculations are working, just #NAME ...

Try this:Here's what I need. 16 golfers put into 4 foursomes every day for five days. Need every golfer to play with each other golfer only once example: Day 1 (Joe -Skip-John-Pete) Day 2 (Joe -Scott - Jason- Harry) Day 3 ( Joe - Craig - Dave -Ken) Day 4 ( Joe - Zilly - Chris - Ed)...

Hello, I'm having a hard time finding the right formula for what I need to do. I need the cell to turn RED if the date in that cell is more than 10 days from the date on another cell. Example: a date will be inputted in cell C3, then another date will be inputted in cell E3. If the date on...

Hey Pros, I use vlookup on a DATE from array "=VLOOKUP($CB5&COLUMNS($CC$4:CC4),$BY:$BZ,2,0)", locate in (CC5), and I want another cell (CI5) to be (CC5 10 days later ), but function =CC5+10 will show #value ! error , please teach me on how to do this correctly. Thank you

In row 3 are dates, from 11/25/18 starting in B3 to today 8/27/19 in JQ3. There will be numbers being entered below the dates...say for row 4. I’m looking to count blank spaces between the numbers that may appear in the cells in row 4. For every 42 blank cells that is the equivalent to 1. The...

Hi all, I'm curious if there's a formula to do the opposite of DAYS360. That is, DAYS360 figures out the number of days between two dates on a 360 day basis. I want to make a formula that adds a number of days on a 360 day basis. So if my starting date is 5/25/19 and I add 6 days, it should...

This is my initial code out of confusion with how Worksheet_Change works Private Sub Worksheet_Change(ByVal Target As Range) With ThisWorkbook.Sheets("Home") If Target.Address = "$B$4" And Not IsEmpty(.Range("B4", "B1", "B2").Value) Then .Range("C1").Value =...

Hi... I'd like to ask if someone can help me to find the correct formula. I have an overtime tracking template for 31 days, the threshold total hours for the month is 303 for 30 days which is 10.1 per day, if an employee worked from 1-31, the threshold should retain 303, but if an employee...

Hello, I need help using the conditional formatting colors on Close Date. When Close Date is less than (270 days, 180 days , 120 days, or 60 days) from As of Date from the NAME (e.g., Introduction, Meeting Scheduled, Meeting Confirmed, and Sales closed) I want the close date cell to change...

Hello, I'm creating a pivot table and would like to sort by the below text under Column Time In Queue. What I've been able to do so far is convert the days, hours, minutes, seconds into a "d.h:mm:ss" format but it looks messy and I'm not sure it's correct. <tbody> Time In Queue Invoice...

Hi All, I am doing Visual Basic and would like to know how i can convert this statement to return the weekending date. The result will only give me a count of days from sunday to the date on transdate.value but not the weekending. WE.Value = Weekday(transdate.Value, vbSunday) Please help me...

Hi, :confused: Confused have put a lot time on below but couldn't find Solved it sadly ;( I have a Senior hopefully might we can Solve below situation with formula. Ever employee has number of Paid laves in his account. But those paid leaves can't be availed all at once. Only allowed or can...

Hi all, I'm looking for a formula to find the number of days within a date range, but only for a specific month (in this case, July): <tbody> Start Date End Date Expected Result (days) 28/06/2019 27/08/2019 31 15/07/2019 15/10/2019 17 01/03/2019 10/07/2019 10 </tbody> In this...