day

Hi Everyone Having searched a number of threads and not found the answer I am looking for I thought I would again call on your collective expertise to give me a shove in the right direction. What I am trying to achieve is from the cell A5 which = Week ending 06/09/2019 I am extracting the date...

I have 3 cells in excel in same column. One has value "Dec, 2014", second one has value "NA_Dec'14" and the third one has value "NA_". As you can see 3 cells have 3 different values. I am looking to extract a date either first day of the month or last day of the month from the second cell which...

Here is a screenshot of the spreadsheet i am working with: https://ibb.co/3smrHPb I have cells B2, e2, H2 etc calculating % of target achievement that calculates % of target achievement so B2 cell formula is =b24/b4 for sales day 18. Each day i have to manually adjust the formula to reflect...

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

I am trying to prepare holiday data for an import into a resource planning system at work. Human Resources have provided me a spreadsheet of all our sites (100+) and which holidays each site observes from 2019 through to the end of 2025. Sites are listed in column A. The date of the holiday...

I am trying to build a formula in excel that will compare two dates. I am using =NETWORKDAYS formula to calculate the number of days in between, and that is working great. My problem is, in Cell C1, I am entering a date of arrival. What I need is: If the arrival date is a workday, then it...

Hello, first of all thanks for your help. What I want to do is to compare the cumulative sales from working days since first of the month to current date vs the sales of the same quantity of working days same month last year. Lets say today is September 4, 2019 and we work from Monday to...

I'm working on a sheet to track inventory. I'd like it to be 'user friendly' and all the associate would have to do is update the inventory quantity each day. The VBA code below automatically creates a 'new sheet' named for the date the file is opened. I do have a Master sheet that needs to keep...

Hello, I have a dataset corresponding to snowfall sum per day, for a number of years (30+). There are often blanks for certain days. Where there is a blank day in a month, I wish to set the entire month (every day in the month) a value M (for missing) or set the entire month blank, either is...

I wasn't exactly sure how to word the title outside of providing the actual problem itself. I have a pivot table that has a dynamic amount of informaiton. My current pivot table has 27 unique dates, the next one I run could have 30 or even < 20. The column header we use is the Received Date...

Dear All, I would like to calculate the cumulative volume of liquid from a pipe over the period of 22 years. Data has been given on a daily basis, however in some instances this covers multiple days. The format of the native data is as follows: <tbody> DAY LIQUID RATE, M3/D CUMULATIVE...

How can I change sheets based on a userform button. If I have a command button on sheet 1 that when it's clicked a userform pops up. But I also want to automatically change sheets to the current day. So say on sheet 1 there's a command button for Monday, Tuesday, Wednesday, Thursday, Friday...

Hello - I've created a timesheet for my employees in Excel. I'd like there to be one particular dropdown menu that shows if the total hours for a day are less than 8.0, and another dropdown to show if the hours are more than 8.0. I know how to do dependent lists, but not how to make a list...

Hi There - I need a working day calculation - but with a twist. Here is my example: A1 = 5/17/19 B1 = 8/1/19 C1 = _________ Part A: I need day #1 to be the first working day after 5/18/19. And then I need the last working day to be the day of B1. And I need to exclude a list of...

Hi, Need some help: <colgroup><col width="64" style="width: 48pt;"> <col width="111" style="width: 83pt; mso-width-source: userset; mso-width-alt: 3953;" span="2"> <col width="64" style="width: 48pt;"> <col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2531;"> <col...

Hi, Please can someone help me? I would like a VBA code that can find the day number of the year based from the current date. Example: today is the 05/10/2019 so I would like the code to return 278. So tomorrow would return 279 and so on. I have the date in cell T3 if that helps any? Any...

Hi if I have date like 13/1/2001, I know i can use day(), month() and year() to separate day, year and month. I also know I can use text to columns. Which method has advantage/disadvantage over other. Thank you so much.

Hello! I am looking for a formula that lists a new number ever time a new time would appear. For example (7:16, 7:16, 8:34, 9:25 = 1,1,2,3) the only problem is, i need this to start over every time a new day appears in another column. i hope that's clear and that someone can help.

I import daily data into Excel for a morning report and the data does not always take up the same amount of rows. One day, it could go down to row 79 but the next day, it could go down to row 90. How can I modify the VBA below so that the code looks at all used rows instead of this static...

i am sent a spreadsheet each day of performance. I have a recorded macro that deletes all the data not relevant to me which leaves me with 5 rows/10 columns of data. The columns are constant each day. I would like the macro to proceed in copying that days data onto a separate master spreadsheet...