todays

Hi, I'm using the following script from another thread to try to have my worksheet (sheet1) scroll down to the row containing today's date on opening. Private Sub Workbook_Open() Worksheets(“Sheet1”).Select x = Format(Date, "dd/mm/yyyy") On Error Resume Next...

Hello there, Looking for assistance. I'm attempting to see if a macro can be created to clear encumbrances on our account reconciliations. On this sheet, we have column F which contains biweekly payroll dates. Then Column G, H, I are calculations made by our team of employee's salaries, ERE...

I am trying to write a script that will do the following: Check to see if column N is empty. If column N isn't empty then go onto the next row. If it is empty then check to see if Column F contains the word "January". If Column F contains that word then put today's date into Column N. Check to...

I am trying to help provide a solution to Forum Post titled: "If column cells certain values, read name and vlookup in another sheet for email" I have worked back and forth with the requestor and had a solution that met his initial criteria. In his last request he is wanting to Filter the data...

Hi can any help with a formula to highlight text within a range that is equal to todays date eg Range H4:N9 todays date is 28th Jan so the value in cell N8 (28) is auto highlighted in red <colgroup><col style="mso-width-source:userset;mso-width-alt:1097; width:23pt" span="7" width="30">...

Hello, I want to create code where IF cells in Column A are populated & Column I are not populated insert today's date into Column I. I do not want a set range (i.e. A1:A100) as my spreadsheet will continue to increase over time. Thank you in advance! Jay

I have a range of data emp number, last name, first name, total minutes, coach and date, there is up to 100 rows as we pull this information daily. I need to be able to compare the date to today's date then copy the first and last name of each employee when the date column equals today's date on...

Using Microsoft Office Excel Professional Plus 2016. I am attempting to create an IF TODAY formula that will recognize today's date within a range of cells, and if true, will shows the contents of the adjacent cell next to the cell that contains today's date, regardless of where in the range...

Hi Guys, I have a question, i have a time card with dates in column C, with the dates of the month filled in each row (example: C1=1/1/18, C2=1/2/18, C3=1/3/18, etc... Can i have a workbook_open code so that it searches that column or range (C1-C50) for todays date and then puts the cursor...

First off, I have found this board very helpful and want to thank everyone for that. I also thank you in advance for help with this new issue. So in order to keep our Work In Progess (WIP) tracking accurate, I'm having the users record activities. These activities are dated by the user and...

Hi, I am looking to copy a worksheet in workbook1 to a named workbook before all other tabs AND name that tab with today's date. Any help would be much appreciated. Thanks. :confused::confused::confused:

I have a column with a wide range of dates which I would like the average of all of those dates to Today's Date. Is that possible? Thank you in advance! i.e. Column A 10/21/2017 10/20/2017 8/1/2017 The average would be approx. 47 days

Hi, I am looking for a way to notify me of any date that exceeds todays date by 2 days If at all possible I would like week days only, but not sure if this is too complicated Many thanks

I have created a link to today's date on a table of timesheet data. I need the formula to take me to the cell to the right (Column E) when I click on the link, but right now it brings me to the date cell. How do I fix the formula? (Go_To_Today is a defined name for the lookup for the date)...

Hi There, I have all text in a cell example Cell A1 Today is hot Last week was cold Today's weather is 18 Next week is 20 I need a VBA code that searches the cell via instring search for example searches "Today's weather" and will return the whole line "Today's weather is 18" which then i will...

Hi Everyone, OK so I want a macro that when I run it it copies the active sheet but removes all the formulas and saves as values, Then renames the copied Sheet to "Bookings" and todays date. without changing the original sheet then I want it to Place in Cell D3 "Ordered" and todays date...

I have data in a spreadsheet that appears to be missing when I attempt to filter it. For example I have the data for month of September open and am viewing todays data but when I go to filter to only show me todays data the current month is not even an option for me to filter nor are the...

Morning all, I created this macro to save my file to a specific folder and use todays date within the file name and it worked great in my test spreadsheet but when I tried to transfer the code across to my user spreadsheet it returns a problem which is. compile error: wrong number of arguments...

Hi, I need to calculate a current progress review based on dates and the current time. I have 5 columns (C,D,E, G and H). C = Progress, a value between 0 and 100. D = A target value (see below) E = Variance (Difference between the target and the current). G = Start Date H = Due Date C12 - I...

Hi all, I wonder if someone can help me with a formula please I cannot get my head around it so its best to write it in words: It is so difficult to explain my actual spreadsheet but here goes: The formula would be filled down the column starting in O2 If the date in E2 IS LESS THAN OR EQUAL...