january

So Column A is a month (January), column B is the date an order was received, and column C is the date the order was processed. I'm trying to count how many times in the month of January the order was processed after the day it was received. I keep getting referred to SUMPRDUCT but that's not...

I have a bunch of data between A12:T1499 I have a bunch of dates starting at the first of the year through the entire year in Column F. Called "Date Order Received" F12:F1499 These are the dates that I'm trying to use to "sort". I have 12 command buttons that have each month on them. So...

I input the month (ie. January / February / march / ... etc.) into cell A1. I'm looking for the formula for cell A2 that will increment cell A1 by one month. I'm NOT using full dates ... just the words January, February, .... etc. So if i put January in A1 ... February will appear in A2 or if...

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 want to use a date as a criteria in my formula. How I typically do this is =IF(B5>A1,...... Where B5 is a date and A1 is a date. Or If(B5<NOW().... But what I am trying to do here is put an actual date in the formula. I want to see if B5 is > January 01,2019. Do I have to put 1/1/2019...

I want to use: =COUNTIF(January!B7:B37,summary!A12) except I want to have the sheet name 'January' taken from a cell so I can perform the countif on a large number of sheets Is there a syntax which allows January!B7:B37 to be replaced with "A1"!B7:B37 in a formula where A1 contains January...

Hi, can anyone suggest what is the best approach to tackle what I'm trying to accomplish? I have 8 columns of header and 132 rows of data per month starting January. I want to create on a separate sheet a dashboard so that the user can use a dropdown list to select 'Month' and another dropdown...

Hi All, Would request your help to help me combine the month and year in separate columns on my sheet into one column which is readable as a date. I tried using the formula "DATE(A3,B3,1)" but it gave me a #value error. reference to A3 and B3 are as below...

Hello Guys, I am looking for help with a formula, I have a spreadsheet, it’s a calendar and it is laid Out like this: January is on sheet 1, February is on sheet 2 Up to December on sheet 12 The Days are in a column B11 to B41 The Dates are in a column C11 to C41 It’s like this on all sheets. I...

Good Afternoon, I am hoping the kind people of this forum can help me arrive to a solution. I have basic excel knowledge, but what I am trying to achieve is beyond the scope of my current understanding of excel formulas. I need to do what I believe is referred to as a reverse lookup (to...

Need a formula, or possibly a macro if necessary, to execute the following based on the current month: If the current month is January then if B1<E1 then D1=""; if B1>E1 then D1=E1-A1. Cell D2 would be if B1+B2<E1 then D2=""; if B1+B2>E1 then D2=E1-(B1+B2). Cell D3 would be if B1+B2+B3<E1 then...

Hi I think I have created my spreadsheet incorrectly as I am trying to create a trend analysis comparing one financial year to the previous year, but also over a period of 12 months (hope that makes sense. I have tried the Insert Line Chart and that's having a fit <tbody> Name Jan 2017 Jan...

Hi, I have create drop down list by VBA so from the list when i selection January to hyperlink (go) cell F2 where is January etc please see picture,attachment an code which I am using. This time I have this code below but this code is so from DropDown list to go to Sheets but I am looking for...

Hi, I have a worksheet called 'Dates' and listed in column A is the dates below. I also have an individual worksheet in the same file for each of these dates so I was wondering if there is a quick way to hyperlink each of these cells to the worksheet that has the same name? I have 1st Jan to...

I am trying to create a Sales Report that will show performance vs last year. I have created a formula to give me yesterdays date with one cell showing the month, one the day and one the year (located in cell C1, D1 and E1 respectively) here are the formulas: =TEXT(TODAY()-1,"MMMM")...

Hi I’m looking for one formula to calculate the day a payment is made. Let me explain. I have a date in A1 which could be any day in the month and in A2 onwards I need to show the 28th day of the month following the date in A1 or the previous working day if the 28th is a weekend. For example...

I have a problem and need some input from some clever people. I have some code which does something based on which month it is. Coloumn 1 - - - - - - - - - - - - - - -Column 2 =MONTH(TODAY())+Z2 - - - - - - -[some code based on the number in column 1, expect number 1-12] Cell Z2 I use to...

Hi, I have a data input sheet as follows: <!-- Please do not remove this header --> <!-- Table easily created from Excel with ASAP Utilities (https://www.asap-utilities.com) --> <table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellpadding="0"> <tr><td bgcolor="#FFFFFF"...

I'm creating a worksheet calendar and would like to hide the dates that are not in the current month. For example, in my my January calendar I would like to show a blank cell where the Sunday and Monday dates of Dec 30 and Dec 31st don't appear (i.e. the cell is blank). I would also like the...

Hello! I have a product report that has some columns - one of them is date: one of two specified (let's say that it's always either 1st January or 9th January). Among all products there are few that always have only one date assigned, but still appear many times in the report (because other...