I think this is pretty basic, yet I still havent been able to figure it out.
I want a formula that returns a cell value, if another cell value (date) occured last month. if the month column is blank or not last month return NA.
A1 has date
B1 has value I wanted formula to capture
what i want to do is.
i want a foumula that will let me to get a rolling average for a month as i add numbers for each week. that total will be in one cell. I want it to be able for it to figure a average for week 1,2,3,4 so that I will have a current average each week.
I have a Workbook which has a sheet for each month and a totals sheet. I'm trying to get Year to Date totals based on the month. ie in cell E1 on the Master Doc tab the month is Jan then in C5 it shows the value from C5 on the Jan tab. If E1 is changed to June 19 I want C5 to show the Total...
I'm wondering if someone could help me on this!
Is it possible to add month instead of range.
Like count unique number in column B for the month of Sep, Oct or Nov. Note that I have column C which has dated when claim number was issued.
Test-Count | Auto-Num...
I have a workbook that uses multiple command buttons to get to the user forms and writes data to multiple sheets. I was wondering if there is a way to get a message box to pop up when I click on my midnight command button and "01" is displayed in cell "C4" on the main page where the...
Good EveningEveryone :),
I would like to create an AutoOpen sub that automatically opens up to a specific worksheet based upon the current month.
For example, we are currently in October, so I'd like it to open up toWorksheets(4).
If its November, I'd like it to open up to Worksheets(5).
I have a situation where i have 12 months in a row acroos my worksheet.( Jan-Dec), and i have 6 catgories with total number of students that attend across the top. each month has 4 dates. so what you have is each month they meet weekly and i have a attendance number.
I another place on the...
I am trying to set up a model that will report for the next twelve months. Each month is on a separate worksheet. I need to show salesperson and sales amount in one of the graphs. Given that sales people may or may not achieve a sale in any one month, I thought that using a pivot table...
My workbook has a tab for each month. When I’m in a specific month, I run the macro below to add a name to the Totals tab. It places the name on the first available row for that months chart. I created name rages for column A for each months chart on the totals tab. Example...
The code is shown below.
I have a userform with Comboboxes
ComboBox1 is MONTH
ComboBox2 is YEAR
Month is to be inserted into cell A3
Year is to be inserted into cell C3
When i press my transfer button the YEAR isnt shown on the worksheet but the MONTH is entered into cell A3
On my worksheet called Sheet1 i have a range I26:I35 with values in.
My intensions are to press a transfer button on a userform & select a Month.
This will copy the cell range values shown above to 1 of 13 possible paste locations on the same sheet depending on the MONTH selected from the...
I am making an attendance sheet to count the number of times a person is present in a certain month. (url to photo of sheet attached)
Column A is Dates, and Columns C-D lists "yes" if present on that date and "no" if not present on that date.
Column G lists months (Feb, Mar, April..), and in...
I have learnt so many tricks from this forum which has made my job much easier. I have another "challenge" now:
I have inheriated a workbook with many cells lookup to a worksheet in another workbook, it is simply, however, the worksheet changes each month, for example, in Oct the...
I know the formula to find the previous month name: =TEXT(TODAY()-DAY(TODAY()),"mmmm")
But how could you modify this to give you minus 2 months or 3 months?
I am looking to reference another column to maybe minus number sequences from 0 - 6 subtracting a month at a time but I need it...
I have 3 cells in excel in same column. One has value "Dec, 2014", second one has value "NA_Dec'14" and the third one has value "NA_". As you can see 3 cells have 3 different values. I am looking to extract a date either first day of the month or last day of the month from the second cell which...
I am trying to create a savings log which would enable us to detail down the savings we generate as a business.
Essentially the main issue I am facing is that I can dedicate fields to detail the saving total along with a date that can be used to identify a realisation month for the saving...
All, wondering if someone can help me with a formula. I need a formula that will calculate the month when total project cost has been spent (e.g. 500 in the table below). In the table below, the correct month is 5.
I have a database where I need to prompt the user to change a specific code number when a new month begins.
I have tried using the following (C is the assigned date column and F is the code # column)): =C18<=EOMONTH(TODAY(),-1). This does highlight the code column cell but I want it to apply...
I've been asked to calculate quarterly dollar spread based on start and end months.
I need it in this format.
removed bad image
Q1 calc is easy, but gets complicated (for me) on the rest. Any help would be greatful. Thank you.
Good day everybody,
I am facing a relatively trivial problem, but somehow I can not continue.
I would like to know how (dax measure) many working days are still available in the current business month from today (in Excel/ Power Pivot).
I have the following table...