month

Hi there I have about 40 files that I need to append through Power Query. In my model the user selects a month and then the sheet with that month name is consolidated. It works great until someone uploads a file that doesn't have any sheets with that month name. How can I get power query to...

Hi, Please see the picture linked to below and open it in a separate tab to zoom it: https://imgur.com/a/8v1i12O I am trying to create a formula to use in O2:Z2 (blue cells). I want it to do the following: Look for invoices in C3:N3, if true, then divide it by number of mortgage months in B3...

Hello everyone, I'm struggling with a problem on a pivot table. I have some data that looks like this <tbody> Date Month Management fee Client Billing amount 01/01/19 January 200 Client 1 500 01/01/19 January 250 Client 2 250 01/02/19 January 200 Client 1 560 01/02/19 January 250...

Hi there, I have this code that's corresponding to a table that pulls the total amount but I'd like to know if there is a way to also make an additional table that you can "edit" or press a button/search bar to look for a person's name/employee # and it pulls just their data? My goal of this...

Hello! I am struggling with a function to link to a macro that requires me to copy a set of values from one sheet to another, while these values depending on a certain month that I link, and then asking the user a Yes or No question on if they want to replace these stored values for that month...

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 am finalizing a production log that I have built...I have a Entered Training Date and a Graduation Date listed. I am trying to calculate the number of days instructed within the current month. I have the formula spelled out that gets me exactly what I was looking for, however, this formula...

Hi, I have a range of data (a few thousand rows and a dozen columns) in a workbook that I update each month by pasting over with the latest version of the data that I receive in an .xlsx file in email. The number of columns is unchanged from month to month but the number of rows may change. I...

This spreadsheet is designed to keep track of the number of mistakes made on important paperwork during the course of the week and for the month made by one of the employees in the list. A brief description of the layout of the spreadsheet. In range A3:A51 is a list of all the employees for that...

I need to create one pivot table for a report. My data currently exceeds the rows for excel, so I took the data and put it on different tabs. The headers are the exact same, but instead of one tab with ~1M+ rows, I have two tabs with ~500K. How can I connect these two tables to one pivot...

I have a range (b2:f2) that displays the weekdays of the week(Monday-Friday). In range(b1:f1) I have the dates corresponding with those weekdays of the week. Where I am located the current date is Saturday, the 5th day of October. Which is still considered the current week. So if I were to open...

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.

Good day, I have a need to consolidate monthly sales data from multiple years for many products. The sales data is in a spreadsheet for each year. The products sold have had some added and some discontinued over the years, and currently an overall master list does not exist that covers this...

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>#DAE7F5[/URL] "] B C D E F G H I J </thead><tbody> 1 Year-Month Product Date Year-Month Product Date Defects Desired output 2 201909 A 15/09/2019 201910 A 17/10/2019 13 201909 3 201907 B...

Greetings, I am trying to calculate the amount of time from a date (m/d/yyyy) to show # years, # month, # day but ignore cell if blank. The formula I am using is IF([@[BEGIN DATE-MIN ]]<>"",DATEDIF([@[BEGIN DATE-MIN ]],TODAY(),"y"), DATEDIF([@[BEGIN DATE-MIN ]],TODAY(),"y")&" year...

Hi, I have the below code which looks for any dates from current year in column B and deletes those rows. Every time I run this code it will be on data from a specific month but could be different years (so always November but could be November 2000 all the way to November 2019). It seems to...

Hello, I'm working on trying to auto-fill a sales table I have by inserting either formulas into certain cells or creating a VBA macro. I'm comfortable working with both so either method to solve this problem would be great. I've recreated the table below since I didn't see a way to attach my...

I am using an inputbox to have a user enter a month( Jan - Dec) The months are in Columns B:M in row 1 I need to know the column number of the selected month. I've tried match and it seems to be failing me. any ideas?

Hello, Can anyone help me with a formula that counts invoice dates? Not sure if CountIF can do this or not Basically count how many items were invoiced in the current month and then another formula to count how many in the previous month Both for the current year. The formulas I am...

Hello, I do not know what is wrong with the below formula - receiving a #Value error: =SUMIFS('WO Report'!F2:F1000000, $B$14,'WO Report'!V2:V1000000,$B$12,'WO Report'!S2:S1000000) Let me break the information down for you, I have 2 tabs: Tables and WO Report. The formula is in the tab...