dates

Hello everyone! This is my very first post on mrexcel.com but I've been a site regular for many months now. You guys rock! I always find a thread of someone having the same doubt as myself, but I now have a somewhat specific query: I have a data sheet that is updated monthly where monthly...

Hello, I have a spreadsheet that looks something like this. Id like to be able to add together the date occurrences by month in VBA (so add all the dates from January to show how many January entries there have been). But also add them together based by their category. So the output from...

I have been looking for a while now, and while I've gotten close, I haven't found that cigar. I have a PowerQuery gathering transactions from multiple worksheets in a file, and I'd like to be able to filter to get only those transactions with dates between a StartDate and an EndDate. I've gone...

Good day, I'm having a struggle trying to figure out how to do something regarding DOW and Dates. For example, in the dataset I have Sunday, August 1s 2021 has the number 100 and I want to compare that against the first Sunday in August 2019, not against the 1st (date) itself because that is a...

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...