current

Looking create a macro that adds a new line WITHIN a cell, Starting by adding the current date, then i add notes My failed Code resulting from "recording" of keystrokes: Sub dw() ' ' dw Macro ' Application.CutCopyMode = False ActiveCell.FormulaR1C1 = _ "10/3/2019-> Lead team...

Hi, I thought I had this resolved. But starting in October it thinks November is the current QTR. This is my DAX columns I created in the Calendar table. These are the 3 columns i created =IF(MONTH([DATES])-1=0,12,(MONTH([DATES])-1)) = ROUNDUP ([SORT]/3,0) <today(),if(roundup(month(today())...

I changed the date on my computer to test the following code so the current date would be a date that falls on a Monday. If the current day of the week is a Monday, display the current date in Sheet1.Range("B1") The error message occurs on the following line of code the word "today" is...

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

Hello, I'm using a vlookup to pull the last four digits of a credit card number, but some of the numbers begin with a zero. here is my current formula =VLOOKUP(G2,Billing!$A:$P,14,FALSE)

Hi All, I'm working with this code in producing a common file folder in the current directory. Sub MakeMyFolders() MkDir ThisWorkbook.path & "\mmyy" End Sub I'd like to use the Format(Now(), "mm-yy") to produce the current month and year for the file folder. Can someone please help...

Hello Everyone, I was hoping there might be someone within this forum that has come across this issue before. I would like to set up some code to review a sharepoint site for the most current file that has been uploaded on to the site. The URL for the site is...

Hi. I have the following code, but Excel doesn't know what I'm trying to accomplish. Hopefully a human can see what I'm trying to do and give me the correct syntax. Thanks in advance. For Each c In Range("J2:P" & LastInputRow) cAddr = c.Address If c.Value > 0 Then ShiftHours =...

Hi All, I have a formula which has nearly 2yrs worth of data =WEEKNUM(TODAY()) issue i have is that means there are nearly 2 of every week. How can i determine in my formula to look at current year only? thanks Samuel

Can you use vba to measure distances in excel, such as between any given row at the bottom of the current page?

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

Hello, The formula in my calculator answer cell is =F10/LOOKUP(F10,Sheet1!$B$3:Sheet1!$B$1000,Sheet1!$C$3:Sheet1!$C$1000)+F5 But I would like to reference a different "Lookup" depending on the value in F4 If F4 is below 15 I would like to reference columns B & C (as in the current formula...

Hi, I have a listbox (listbox1) with the numbers 1-52 in it. I would like a code that highlights the current week when the userform is loaded. Any help would be much appreciated. Thanks Dan

I just want to give a path to download the attachments, but no success, It is now a hell of the code. is always opening the browser folder which should not be the case. it should directly download the attachments in strPath. "strPath" its not working, Code strPath =...

I am looking for a formula that counts all the dates in a list of the current month and of the previous month. I have this formula but I am getting no results when I should be receiving: 210 results =COUNTIF(G2:G1000000,MONTH(TODAY())) Any help would be appreciated Thank you Carla

Hello, I need help moving an arrow shape in my worksheet. My Workbook has 2 Sheets: One is a Grid to display the users Current and Projected Retirement Percentage. The other is a Setup-sheet where the user enters their (Birth Date, Hire Date, Current Hourly Wage, Planned Retirement Date). When...

Good day! I hope someone can assist me with the following problem I am trying to get a return value of Yes/No indicating if the customer is active for the current month based on the following (which are all dates) Example 1 Contract Start Date: 01/01/2014 Contract End Date: *blank* Current...

I am trying to write a macro to automate copying data from an exported CSV Sheet that is dynamically named with the current date and time. For example, the current file name is Portfolio Review20190920_1013. Is there a way to identify this file by the current date and time? And what would be...

Hi All, Noob here :) Need help with IF function. I have Data from Cell A2 - K2 Cell's B2 to K2 displayes "Yes" or "No" it compares previous week roster to current week roster I wan't to display Data in A2 using IF if there was changes from previous week to current week. I was thinking of...