december

Hi All, so basically i have the following table <tbody> A B C D 1 Start Duration Depart Month 2 01/11/2019 61 01/01/2020 January 3 01/12/2019 18 19/12/2019 December 4 19/12/2019 26 14/01/2020 January 5 25/12/2019 5 30/12/2019 December 6 30/11/2019 43 12/01/2020 January 7...

Hello, I started learning VBA yesterday,.. please bear with me if this is v basic,.... I have a set of data in a worksheet that will vary in size. i would like to copy the value in cell P2 (10.10.2019) down to the bottom of the column,.. which is currently 4000 rows long. <tbody> Column P...

Hi Experts, Sorry for wastage you valuable time for my critical issues! as a HR staff, i need to calculate actual staying time if he intermittent input in my organization for example <tbody> Name of Organization Period ABC Company from 3 October 2010 to 25 January 2014 XYZ...

I have some calculations that are strongly dependent on "this week", "next week", etc. Let's say I have a date (Column A). I can use <code style="margin: 0px; padding: 1px 5px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height...

Hi, I have been looking and trying for a formula that will return a given value from a different cell for the last given date of the month of June and the last given date of December. So far I haven't been able to create a correct one. Hopefully it is possible. Dates are in column A and spread...

Hello, I am having difficulty since I have never used Excel to understand a great deal of what I am reading. I need to count out weeks, 4, 6, 8 depending on what client I am working with from July 15 - December 24 2019. I cannot figure out how to use the excel sheet to make that happen. Can...

My workbook contain 13 sheets. One sheet for each month (January thru December) plus one sheet to be ale to run totals. I can easily use =Sum(January:December!B2) to calculate the sum of all B2 cells in sheets January thru December. However, i want the ability to select the range of sheets...

I need to create 12 new sheets in a worksheet and label them january to december? Not too bad as a one-off but probably have to it quite often so automation would be handy. they would be sheets 1 to 12 and there will be a sheet 13 and 14 and , one for data and 2 for summaries but i could put...

Hello everyone. I'm from Italy and I need to calculate working days taking into account Saturdays and Sunday but also Italian festivities: Januay 1st - New Year January 6h - Epiphany April 25h - Liberation May 1st - Labour day Monday of Easter (variable day, of course) June 2nd - Republic Day...

Hi, presently using the following: PreviousReport = VAR CurrentDate = [Present] RETURN CALCULATE([Expenses], Raw_data[MONTH] = MONTH(CurrentDate)-2 ) [Present] is the date of today [Expenses] is the measure of interest. This works well from february to December of year n...

Hi All, I have an excel sheet where i want to work out peoples totals for completed tasks. Example Data <tbody> Date Operator Account 01/12/2018 John Doe Mr Smith 01/12/2018 John Doe Mr Smith 02/12/2018 Jane Doe Mrs Smith 05/12/2018 Jane Doe Mrs Smith </tbody> so from the above...

Greetings Folks, I just can't think of how to make this work, I don't know if I'm just mentally exhausted by working on a dashboard all day, but I just can't figure out how to do this. I have 12 columns for Months.. January - December. I'm trying to take a number and I would typically divide...

hi, i'm trying to make a formula so that the next quarter, third friday is shown....(ie December 21)

I have a list of movies and the corresponding date of release. I'd like to do a vLookup to find any movies that correspond to the date but not the year. Here's a sample table <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col...

I would like to change the month in a specific cell every month and have the formula average the month after through Dec. automatically. I wrote the below formula which is not working. For example below I would like the average of June through December by asking it to take May + 1 Does anyone...

Hi. I've got an excel with a list of records, among the ones, there is a column with dates. I need them to be in format dd/mm/yyyy, and visually they are, but somehow internally they are in format mm/dd/yyyy because when I apply a filter to them, it displays values that don't exists: from first...

Hello, I am linking cells from a workbook named new stock 2018 . the said workbook will have 12 sheets by the end of the year for each month from january to december . but it currently only have 5 (january to may.) I have linked all 12 months by making dummy sheets of june til december with no...

Hi Team, In sheet2 I have some data for 2017 and 2018 from January to December of product A to Z Here I take the balance of products using sumifs (=SUMIFS(Sheet2!D:D,Sheet2!A:A,"2018",Sheet2!B:B,"JANUARY",Sheet2!C:C,F4) formula in sheet1. I want to do this activity as a macro using...

Hi, I have got cleaned and transformed a large data set generated by our server, in Excel 2016 through its "Get & Transform" feature. All was OK and amazing except the error in date format. Server had generated the date as "dd.mm.yyyy" format. The G&T is unable to format date greater than 12th...

Hi Everyone, I have following dates that in excel column L and i need to convert all into a valid date and time format? <tbody> December 10, 2017 at 8:29:55 PM GMT January 30, 2018 at 7:37:48 AM GMT January 4, 2018 at 9:02:29 AM GMT February 8, 2018 at 12:02:29 AM GMT March 5, 2018 at...