january

Hello, I have a workbook that consists of 12 sheets for 12 months (eg. January, February, March, etc) I want a text box asking the end-user to enter a specific month's name and thus taking the user to that sheet while making that sheet active. But that's not all, some sheets with the month's...

Dear Sir, Madam, I have the following issue. I have inputfile with only data on the 1st of january and the sixth of january, but I have to fill this in on a full calendar list. I tried to solve this by using an IFERROR , INDEX and Match function, but as you can see in the attachment it only...

Hello all, Is there a formula that will work for this? I want to type January 2018 into a cell (or two cells - Month/Year) and have another cell populate 1/1/2018. <tbody> Month Year Date January 2018 1/1/2018 </tbody> Thanks!

Hi all, I need to calculate how many Mondays, Tuesday's etc. an employee worked over a given time frame. It's not as simple as "tell me the # of Monday's between January and May.' See my condensed example using Thursday (i.e. how many Thursday's did this employee work between January and May...

Hoping someone can help... I have a workbook with individual sheets named January, February, March etc through to December. I have another tab named 'Hive DR'. In the monthly tabs (January, February etc) I would like to copy Row 15, 26, 36, 40 and 41 from Column D through to AH and paste this...

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

Hello, I'm hoping someone can help me out with a code I'm looking for. I want certain values on my spreadsheet to increase automatically every year (january 1st). Is this possible with VBA coding? Thanks in advance!:)

I am not 100% sure how to write the formula for this? On Sheet 1, I have various dates for new hired EE's. On Sheet 2, I have a list of "From Date" and "To Date", with the corresponding Week number. If the New Hired EE date falls between the From and To Dates, I need to have the result return...

Hello...I need some help with date-related formula: I signed a 3-month contract with a client in the amount of $300 effectrive from January 15 to April 15. I would like a formula that returns the revenue each month as follows: January: $50 (pro-rated since the contract started January 15)...

I want to modify the formula below and consider a date range Count cell number in column D from January 1,2017 – March 30 2017. Count blank cells in Column E from the cell number January 1, 2017 – March 30, 2017 in column D Count if cells in column E is greater then zero – Range is the...

Good Morning All! I hope I have an easy one for you this morning. I've got about 96k rows of policy numbers and 12 columns starting in column B (Jan-Dec). If a policyholder called within that month it displays how many times they called. I'm not concerned with how many calls they made, only...

Hello Dear, i use the below formula to get the count number of the specific cells based on month which are exist on the E column, it works correctly but while it face any cell that contains formula without result it will be (#Value) please your help to avoid this and only consider the dates and...

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 guys. I am trying to count my expenditures using excel. (I know, I am probably developing a wheel again). I have met difficulties, when realized, that the date "31st January" may have not one but plenty different types of expenditures. So I cannot use one row for the 31st January, but have...

Hi, I want to know if what I am thinking is possible and if so what should I Google to find out more? I have 5 workbooks, each workbook represents five different branches of a company and each workbook has worksheet tabs from January to December (12 tabs in total) in which an invoice is for...

Hi all, I'm in the UK so 1st march is 01/03/18 ...everyone else is wrong! Including excel it seems. I am using =text(month(A5),"mmmm") which is returning January. Strangely =month(A5) returns 3, its the text that's converting it to 1 I've tried =text(month((A5)+3,"mmmm") still produces...

So I've tutorials online on how to do a rolling month, but I have a unique circumstance in that I need a month to duplicate. For instance Cell B1 = JANUARY I need the output to be JANUARY JANUARY FEBRUARY MARCH APRIL MAY JUNE..... If I change Cell B1 to April, my output needs to be...

Hi, I have what is probably a simple problem, but I can't figure it out or find it on google. I would like to format the cell that contains the date and the two next to it, based on the month of the date. I want 4 colour depending on the month so 1 colour for all dates January to March, a...

Hi guys! Need some help regarding this matter. I have something like this data in a table: <tbody> Column A Column B Column C Column D BP January Item A 56756 BP January Item B 4353 BP February Item A 235 BP February Item B 67457 BP March Item A 4577 Expenses January Item A 3452...

Hi All, Help me! I want to count the ticket numbers with following conditions. 1)Count should be according to the month and the ticket type 2)If the ticket is opened ex: March and Closed in June then the ticket is carried forward to April, May and ultimately closed in June. So the count for...