1st

Hi I'm sure this is a simple one but i cant figure it out. I need to drag a formula accross my row so that the results in each column are like this 1st row =sum(A1:A7) 2nd Row =sum(A8:A14) 3rd Row =sum(A15:21) etc Thank you

Hi, I can't seem to find an answer to this one anywhere. I have supervisors who add required delivery dates to a shares workbook. For example, if they want something delivered in a weeks time, they would add 1st June. I want to also log the date they put the date in, so that it doesn't update...

How to create a list of dates of every 1st, 3rd, 5th Monday each month between two dates? I have in cell A2 (01 Jul 19) the first date and in B2 (30 Jun 20) the second date. How do I populate column C with the dates of every 1st, 3rd, 5th Monday each month between 01 Jul 19 and 30 Jun 20...

I am working on automating a friends finances in Excel. If my friend has income on the 1st of every month, and I have a date range pre-defined... I would like to automatically add a pre-defined amount if the 1st of the month falls within a date range. E.G. J1 = 8/29/2019 J2 = 9/5/2019 A1 =...

Current Formula is - =IF(OR(ISBLANK($AJ2)=TRUE,$AJ2="Issued from History"),"Complete", IF(AO2="Process Support","Closed","Closed")) here problem is, when im selecting "process support" in col AO all my answers are not shown as "Closed" because, as per the 1st OR condition if col AJ finds...

Hello, I am trying to find a couple formulas to extract the amount of hours worked on each shift. Time is entered beginning and end of a shift and may include a portion of all 3 shifts. 1st shift is 6am - 2pm, 2nd shift is 2pm - 10pm, 3rd shift is 10pm - 6am. Example if I punch in at 5:45pm and...

I have a column with dates. Usually it consists of dates only within one month, but very rarely it has also 1st day of the next month. I need to find maximum (latest) day number to use it in many different places in my VBA code. Currently it looks like this: FindLastDay =...

Hello! I am having a hard time doing this in excel, and variations of it::confused: how can i calculate the monthly price i need to pay to pay down 2 accounts 2 0 where the 1st account is worth 2000 and has 0 percent interest and the 2nd account is work 10,000 and has 5 percent compounting...

HelloWorld, I have this challenge here with me and I need some help. I want to look compare the day and month of the date in cell A2 with the date ranges below. Then when I find a match , I use that match to select at random one item from one of the arrays. So if the match is seen in...

I am trying to display the number in the cell above the row of percentages that 1st hit above a particular percent. <colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody> 1 1 2 2 3 3 4 4 5 5 1.05% (1.01%) 0.90% (0.85%) 1.30% (0.75%)...

HI all I have setup vba code to get comments from another workbook. It works fine until I close down all workbooks and reopen. Then then link has changed from =GetComments('[EPN - SPN - ROTA 1st April 2019 to 1st April 2020.xlsx]Rota 2019-20'!J35) to =GetComments('\\Ukpnforfs01\1$\Power...

I'm at a loss on this. I need to find the Overall +/- performance % of errors made over the 4 quarters of the year. I can get the performance +/- from the previous quarter but the overall is a mystery. My data is: 1st 2nd 3rd 4th 50% 67% -55% -78% Keep in mind that positive % =...

Hello everyone, I got a workbook, where i have 31 sheets (one for each day of the month). Then there is a final sheet where i got a column with every day of the month. When i set a formula in the 1st of the month to read a specific text from the 1st sheet, everything goes ok. Instead of doing...

I have 2 workbooks open that I want to compare using view side by side function and also synchroinous syncing . Is there anyway that I can create a macro so that it looks down the two workbooks comparing data and if missing from 1st sheet it highlight it. I want to look in the 1st sheet on...

I have downloaded an Employee attendance record Excel Sheet that keep tracks of days of such as sick day , vacation etc and it seems pretty good. Located here: https://templates.office.com/en-us/Employee-attendance-tracker-TM02780235 But currently it goes from January 1st to End of December is...

Hi There, i have searched a few threads but nothing i can use, i am plotting month end dates across the horizontal axis, they are not the last day of the month but the last friday of the month, hence no standard gap from one month to the next. isuspect this is why excel is changing all dates...

Hello friends, Hope all is well! I have two columns in a powerpivot database; each column has two DAX formulas: The 1st column A: has the following formula: = CALCULATE(MIN(db[Comdt]),filter(db,db[Employee Status]="Term"),FILTER(db,db[Full Name]=EARLIER(db[Full Name]))) The 2nd column...

Hello everyone. I'm from Italy and I need to calculate working days taking into account Saturdays and Sunday but also Italian festivities: Januay 1st - New Year January 6h - Epiphany April 25h - Liberation May 1st - Labour day Monday of Easter (variable day, of course) June 2nd - Republic Day...

I have a workbook that is set up to always stay open with a Private Sub Workbook_BeforeClose function. I have written a macro called Save_And_Clear to perform a number of routines on the 1st of the month at 7AM. The Save_And_Clear macro works great but I’m having a hard time figuring out the...

Hello How can i get the week defined as 1st week ,2nd week , 3rd week and 4th week of a particular date which falls in Particular Month For eg if i enter 01-Feb-2019 ie in dd-mmm-yyyy then in next adjacent cell to display as 1st Week of Feb 19 14-Jan-2019 to be...