august

I have a large sales data report containing severalgroups of customers. I would like to automatically generate individual usagereports (separate files so not by tab) from this large file for each groupevery month and save them separately on a shared drive. I would like to also have each...

Hi Guys, I have an issue with a formula. I need an if between dates with in the middle August. Example: 12/06/2019 12/10/2019 If in the range there is august do something, otherwise something else. I have no idea how to write it. Thank you guys, Have a nice weekend.

Hi folks, I regularly have to compare 2 report lists (approx 10,000 rows on each report) that are nearly identical. However, there are always 3 types of differences (sorry my title says just 2 I couldn't edit it) throughout and I currently spend a lot of time finding/listing these differences...

I have a large sales data report containing several groups of customers. I would like to automatically generate individual usagereports (separate files so not by tab) for each group every month and save themon a shared drive. I would like to alsohave each report automatically be customized...

I want to add a field on my form that will act as a "Title". Actually I have 6 fields. In the first one, if todays date is in the month of September I want it to say "September" in the field. I would even be OK with the Month and Year (But not the day). In the next box if today is 9/17/2019...

Hi community, I want to know how can i calculate numbers between specific rows? if user selects January from data validation list i want excel to calculate numbers from January to august, if May than from May to August. btw user can select start and end date. so it can be from january to may...

Hi All Our accounts software accepts bulk upload of journals from excel, the format is as below: <colgroup><col><col><col><col><col><col span="2"><col><col><col></colgroup><tbody> Batch Date Batch Description Batch Type Main Location Nat Dept Amount Description Journal Code 20/08/2019...

Hi, I have a graph based on a 3-column data table where x- axis is time (months, Jun 2019 to Dec 2020) Primary y-axis is account balance ($0 to $3.5m) Secondary y-axis is PnL (-$300k to $200k) August 2020 is first month PnL > $0 (Aug 2020 as the answer is calculated in a different cell) How...

Hello All, Here is my situation, i'm using excel vba on a spreadsheet. All the values of column K are in mm/dd/yy ie (8/7/19). Now i have made a macro that take information from this sheets and fills a few word documents. My problem is that they now want the documents to display the full...

In my spreadsheet in E1 is yesterday date in this style 31/07/2019 is there a way of adding to my macro a way to save as T/P5 August 2019/31.07.2019 Contact Finance

Is it possible to make this "Golf Course Count Table" (on the right) without the "Day" cheater column? and just get the info from the "Date" column? <tbody>#DAE7F5[/URL] "] AC AD AE AF AG AH AI AJ AK AL AM AN 3 #548235[/URL] "]Date #548235[/URL] "]Day #548235[/URL] "]Time #548235[/URL]...

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

Hello; I need a function (or 12) that tells me for each month how many times it appears between two dates. So let's say I have the dates 1.1.2019 and 31.7.2020. The output should be: January 2 February 2 March 2 April 2 May 2 June: 2 July: 2 August: 1 September: 1 October: 1 November : 1...

how can I transpose the info in EXCEL from....to <colgroup><col><col><col><col><col><col span="2"><col><col><col><col><col><col><col></colgroup><tbody> FROM excel in tab 1 code product Jan feb Mar April May June July August Sept Oct Nov Dec 31010054 3 49471 45847 53911 50423 53134...

Hi I am trying to get a formula to calculate the amount of Y's and N's for one month i.e. April 18 per project and my dates vary from the beginning and ending of the month. My data is below: <colgroup><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col><col...

I am in need of a formula that will allow me to flag if they have a balance within a +-$1.00 range: For instance- Month: Client: Account Balance: August Bob 10.01 August Lucy 11.27 August Sam 9.56 Sept Bob...

column b has a date, column e has the amount. I would like to know my total for August (data only has 2018 dates)

Hello, I'm trying to automate some of the updating I do within an excel 2013 workbook. Each month, I refresh the rolling-6 month data for the past 3 years and add a new rolling-6 months of data. to do this, I manually filter and delete the respective periods. As an example, if I'm doing the...

Hi all! I have what may be kind of a complex issue. I’m currently working with a data set and wondering whether there was a DAX formula that will create a flag that will place students in one of six categories based on the order in which they completed a test. Essentially I would like to...

Hi I would like to seek some advice on how I can do the following. I have a macro(I use a do while loop to check and insert the extra row) that sorts out data in a certain format by inserting a line(row) in between 2 rows effectively separating the data set. After running my macro, I am...