days

I thought this would be simple but my attempts are not working for me. I need two things PLEASE. I am trying to calculate the total number of "days" between two dates, and secondly, calculate the number of "week days" between the same dates. Each would be in a separate cell. I am totally...

Good day all, My excel skills are very poor. I have a situation where I want compute the average number of times a student attends class consecutively over a period of say a semester. Rows represent individual students and the columns are days. In the cells are either 1 if students attends or...

Hi I have the table below. I want to use conditional formatting or any other way to highlight the event based on condition like the following: If the event takes less than 14 days, then I highlight "Current" in the 3rd column. but not to highlight the "xmas" or any other events which have...

Hi everyone, Im trying to go above and beyond by making an inventory sheet for work. I want excel to highlight the expiration dates of items that will expire in less than 30 days but I have no idea to write the formula(s). If I write out what I want to have happen it looks something like this...

Good day everybody, I am facing a relatively trivial problem, but somehow I can not continue. Aussprache lernen I would like to know how (dax measure) many working days are still available in the current business month from today (in Excel/ Power Pivot). I have the following table...

Hello, I have a data set bunch of work dates for a list of employees in 2018, with a breakdown of what's billable and what's non-billable days. I also have travel reports to indicate date ranges that they were in London. Is it possible to figure out of those days they were in London, how...

Hi I know how to find number of days between start and end dates by simply subtracting end-start. I also know how to find how many working days between start and end date using networkdays() function. My question, how can I find # of months between a start and end dates? and also can I find how...

I have a date range in Row 4 that looks back dynamically 21 days. The formula works off of today's date -21 then gives me each day after that. Currently the date range shows from 9/30 to 10/21 from left to right. The right side is closer to the current date. What I am trying to do is have a...

Hello everyone! I' like a cell to be automatically hightlighted when the date in that cell is 15 days older than the day I type in that cell! For example, today is October 21st, and in cell F5 I am typing the date October 1st. I'd like that cell to be highlited (I'm going to use it for the...

Hello, I hope I can explain this properly as english is not my native tongue. the first table takes its information from the bottom table that is usually in another worksheet by using Index Match I've been trying to make my 3rd column (2+) add the amount from the Indexed Matched row if the age...

Hi, I have a Table with days like this: I need a formula that if x number of days have passed it will do something. For example, if 5 days have passed since last time, "sum these two values" column A= C+D, if 5 days have passed since last time there was a value in the column: <tbody> 1...

Hello Mr. Excel Community - I'm trying to forecast payment date/amount for some payment terms that are more complicated than the usual net 30. Does anyone have any recommendations here for some formulas that are dynamic? Here are some of the payment terms: <colgroup><col></colgroup><tbody> 35%...

Hi I have put together a spreadhseet for Gant chart and alignment, However it is not seeming to work proplery as the % is not showing as the right way. I have names which show the days off as 100% and days in as 0% Can anyone help if I post the sheet???

Hi, Can't attach the the file to the post as there is no option to do so which I need help with but this is where the file is located: https://trumpexcel.com/excel-leave-tracker/ What I want to change in this file is to include “IN” and “OFF” on the calendar days that employees are working and...

Hi Everyone, Based on dates that are provided in column 'C' can we calculate how many days a employee had worked Like, <tbody> Column C ....... Column DI Column DJ Column DK Column DL ....... Column DT 30 31 30 31 31 DATES ...... APRIL MAY JUNE JULY ....... MARCH 14-04-2019 ...

Hello, I am looking to get the following result: So basically I need to figure out how many turnaround( airplane comes in gets services and departs with another flight number to different destination) I have between two dates and week days. For example: Start End...

Hi- I built an excel calculator that will determine the numberof total work days between two dates. The tricky part I have is I need to avoid all weekends. I have a start date in C16, and the problem Iam having is, if that date in C16 is a weekend of a holiday, (I have an arrayin L16:L28 for...

Hi all, i am just started to use macro recently , and i face issue after creating the macro it worked fine for few days then it bring Debug error message although i didn't make any change in it, any advice?

Hi, I am trying to create a heat map using conditional formatting for 3-color scales with formulas. The heat map is supposed to work like this: Input a target date in cell D2 Input the date the Item was completed in cells A2-C2 If the completion date is more than 60 days prior to the...

I need some help with a formula and I've tried searching but not finding an exact match to what I'm looking for. Column A has hundreds of dates, past, present(today), and future. I need a formula that will tell me how many days old (by interval) any past dates are. The intervals would be 0-5...