january

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

Hello All, I will need help with below tables calculation... There are huge datas all the way down from column A. So if its possible I need to place formulas to get proper calculatin base on given table below starts from column J Many Thanks...

I am trying to figure out how to apply a toggle box that enables a macro to run on the current row it is selected on. I have an example spreadsheet that has 2 worksheets. The first Worksheet for the current Jaunary 2018, and the second worksheet is for the January 2017. The column A1 is labled...

How do I format cells with the following date format: Months all in caps and the year JANUARY 2019 FEBRUARY 2019 etc. Thanks in advance.

Hey community, I have database in sheet2 which column A contains month names from january to december. and column b,c,d,e contains number of products sold in that month. i use datavalidation list ( months ) in sheet1 when you choose month from list, result of that month appears. (...

Hello, I have 4 month: January, February, March and April in range A2:D2 January actually means 1; February - 2; march - 3 and April 4 I need a code, that converts month name to number and return number Lets say row 3: February, february, April, April = 12 (2+2+4+4) row 4: January, April...

<tbody> A - Month B - Date C - Period D - Price A E -Price b =date(year(B2),month(B2),1) 01/01/2010 1 32.22 33.01 =date(year(B3),month(B3),1) 01/01/2010 2 30.72 31.78 =date(year(B4),month(B4),1) 01/01/2010 3 30.91 30.65 =date(year(B5),month(B5),1) 01/01/210 4 25.91...

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

<tbody> A B 1000 2000 </tbody> SHEET 1 <tbody> A B 3000 2000 </tbody> SHEET 2 what I want is it will automatically paste it on the next sheet next blank cell. so its like I have already January data and this data is February. I can send you the excel fill if that...

Hi I have a list of contracts that includes their end date and their annual value, e.g. A1 = name of contract B1 = 31/12/2018 (end date) C1 = 500,000 (contract value) I want a formula to count how many dates in column B fall within a particular month and another formula to sum the...

<tbody> January Dept. Name & Surname OFF OFF OFF OFF OFF OFF OFF OFF </tbody> Good Day, I have huge list like given above all the way down from the columns A to AH those datas located on the sheet named "list" I need to put a table to another sheet like below to show...

Hello Excel Experts! I've got a column of dates, formatted as Day, Date, Year. And, I'd like to count all the Sundays using an array formula (like countif) So, Sunday, January 6, 2019 Monday, January 7, 2019 Tuesday, January 8, 2019 etc. It's easy as pie to create a helper column, just...

Hi there , Please help <tbody> month worker month no of workers Jan john jan ? Jan james feb ? Jan james Feb james Feb james </tbody> i need a formular in the cells with question marks. The formular should return the number of workers in each month. Eg January should...

Morning all I was wondering if anyone could help me with a formula. I need to create a lookup using 2 criteria (department in column A and department in row 4. All the departments are listed A5 to A50 and Months B4:L4. So the first one would be Finance is in cell A5 and January is B4 and so...

Hi Guys, I have been searching around for an answer to this for a couple of hours and struggling to find a solution. I would like to add a dynamic mean line into a pivot table/chart dependent on which department and month I am looking at. Source data is set out like this where I have a...

Hi everyone, I would like to be able to summarize unique values from two different columns. Here is my example: Column A (Month) | Column B (Name) January John Doe January John Doe January Clark Kent February...

Hello all, I need some help creating a formula as follows: On sheet2!B2 I have some dates formatted as 01.01.2018 02.01.2018 03.01.2018..... On cell g2 I must create a formula to do something like this : If the date on B2 is in January, copy sheet1!CU6, if B3 is January, copy sheet...

Good morning, My dilemma: I have a spreadsheet that roughly looks like the one below. IT refreshes that file every week with an additional week of data. <tbody> DoorID CustName January Week 1 January Week 2 January Week 4 February Week 1 February Week 2 ..... 12345 Macy's 10 13 20 2 9 ...

Hello, I am trying to figure how to count cells if a range contains a date that is in the month of January and another range in the same row is greater than zero. I have read online that a blank cell will make Excel think that the blank cell is in the month of January. I do have a formula...

I have sumif formulas calculating the net for the month; all of them work except January. January also counts cells that don't have a date at all. The users want to calculate their net before taxes, so the taxes date is left blank so they don't factor into any month. However, January then...