dates

I have a list of time off requests that are listed as date ranges (ie. 6/7/21 - 6/10/21 ) and I need to make a count of how many days off are requested for each date, ideally without having to manually input each date between the date ranges. So i want to be able to input 6/7/21 - 6/10/21...

Hey guys. I will try and explain this in as much detail as I can and hope you understand! So effectively i have a data set of around 370,000 rows of data, one row (price) for every minute of the year. However, there are many minutes that are missing and thus i need to flag them as missing by...

Hi, I am hoping someone could assist me please. I am helping someone with a spreadsheet and they are wanting to flag dates at various stages. Essentially they are looking for two queries; - When 10 business days have passed column P (Closing date), column W (Selection Report finalised) will...

Hello there, I am a new member in this forum (just joined now). I am in my Excel learning journey and I hope that I can make contributions to this forum soon i.e., hoping to be active. Greetings aside, here is my problem. I wish to make a row of dates (not in columns which is usually the case)...

Hello, I am calculating a weekly score for number of steps performed. I'm taking the top 5 days out of the 7 days in a week using this: =AVERAGE(LARGE($B$2:$B$8,{1,2,3,4,5})) The NO HOLIDAYS table in my spreadsheet is working perfectly. The HOLIDAYS table is just a copy of that table which...

I am trying to do away with column B on my spreadsheet by using conditional formatting to highlight column C. Currently I visually check the dates in column B to be prior to today to determine which budgets need to be actioned. I though I had the conditional formula right but nothing happens...

Hello All, I hope everyone is keeping healthy & happy! Just a quick question. I have a userform that contains four textboxes; 1x start date, 1x end date, 1x Alternate Day number & 1x result. A user enters a starting and ending date, eg "01/oct/2020" and an end date "04/jan/2021". In the...

Dear All, I am looking for a simple formula, which will display the number of days in a year. Kindly help me. Name DOJ EOS 2013 2014 2015 Employee 1 01-01-13 08-08-15 364 364 220 Employee 2 05-04-14 31-05-16 270 364 Employee 3 15-02-14 16-04-15 319 106

Hi all! I'm having some issues getting this to work (im a newbie) Im using a xlookup to look up someones name and return a daily stat - however the 2 sheets im using both have dates attached, is it possible for the lookup to return "the name with the stat if the date matches ? not sure how...

Hi Folks! Not sure if this is even possible to do (I'm a rookie) - please ignore the #Name i know the formula as is works its just because i have saved it on another PC on a old version of excel to send this and i had to change the names for privacy reasons. so basically i have 2 tables the...

Hi All -- I am just looking for some help on the following issue -: I am trying to find a way where, I can return the week number, within a specified date range, based off an entered date. In the example below, if I enter a date in column E, column F will return the Period for which that date...

Hello! I've got a list of dates that span across multiple years. Is there a formula I can use to find the earliest date available in each year? E.g. from the dates below I would want the formula to return 06/01/2021, 30/03/2020 and 10/05/2019 Dates 15/01/2021 08/01/2021 07/01/2021...

Good Morning and Happy (belated) New Year Team Mr. Excel. I am trying to figure out how to do conditional formatting on my spreadsheet. (Excerpt below in a XL2BB format) My goal is to grey-out (for lack of a better term) any rows where the date (Column A) is in the future. The table includes...

I am working on a tracking spreadsheet to manage my time and leave. Since I get leave increments credited to my profile at the end of the month I was trying to figure out how to add one month to the date in the cell above. I saw the instructions on Microsoft's website suggesting the use of the...

Hey everyone, I have a fixed table with dates (x-axis on desired chart) that go for several years into the future, but data (y-axis) that only goes a few months. This will be a working file where new data is added each month. I'd like an area chart to show the data across the dates that have...

Dear All, Please see below image, i have this job i need to do this manually everyday, if this can be automated it makes my life easier. I need macro that Populates usage end date in column T i hope i made instructions clear in Image, if anything more reuired please ask. Many Thanks for your...

Hi First time posting so please be gentle :) I have a set two sets of dates one in column E (Target Date) and one in O (Actual Finish Date) The sheet I have inherited uses the below formula: =IF(O2="",IF(E2>NOW(),"OPEN","OVERDUE"),IF(O2>E2,"FAIL","PASS")) What I need the new formula to do...

Hi - I am checking if any projects at work fall between a change freeze - either their start or end date. There are a few scenarios - projects starting within the period and then going several months ahead, projects starting before and finishing during the project - but essentially each...

I feel embarrassed to ask this question but I have searched for a solution and can’t find the solution. I have several dates in Column H. I want to format cells that have dates than are 365 days or older Red. I want similar formats for cells that are between 365 days and 180 days Orange I want...

Hi, Consider this table of employees off sick. Person A has had several periods of time off, and they happen to be all consecutive, totalling 158 days. I am struggling for a formula/Method to return the number of consecutive days Person A has had off?? Person Off Date Back Date Days Off...