1. hayleyg123

    Vlookup between two dates, fix ignoring 1st and last of the month

    Hey, newbie here ☺️ I have a sheet where I want to return the job value (Column H) to a certain column depending on it's expected order date (Column T) So I have this for my formula... =IF(AND(T8>$W$2,T8<$W$1),H8,"") However, if the expected order date is on the 1st or last day of the month...
  2. G

    Find Missing Day of Month

    Column D has a list of the dates the market was open, column K has the market close on that date. I would like to find the value of the market close on, say, every 14th of the month. However, if the market is closed on the 14th (weekend, holiday, the week following 9/11, for example), I want...
  3. S

    validating date in excel VBA

    Hi All, i am a newbie to VBA and find thread on this forum very helpful. I am developing a macro to validate soem fields in excel. one of the column in this excel can haev a date type of data( please note the format of this field is not date ). I am reading the whole data of the excel into a...
  4. A

    Excel - Max date by range from another workbook

    Hello, This is my first time posting in such a forum. I'm not very good with excel but I understand the basics. I've tried looking around the internet for a fitting formula to my problem and couldn't find something specific. I need a formula that will take 2 numbers from Workbook 1 Columns A &...
  5. M

    VBA DATE on open with variable based on time

    Good evening everyone I hope you can help me with this. I've searched high and low and have found my googling skills to be lacking for this. I'm looking at having VBA give a date based on time from sheet1 to Blank Officer on workbook open. this is some of the coding I have put together but its...
  6. D

    Use months in this code rather than dates

    Afternoon, Trying to use months rather than dates in this code. Any ideas on how to alter the code? Public Sub PromptUserForInputDates() Dim strStart As String, strEnd As String, strPromptMessage As String strStart = InputBox("Please enter the Current JobNos.First...
  7. O

    VBA date calculations based on new input date

    Hi all, I am working on a macro to complement something I have already written, where the user inputs the required finish date, and the macro automatically calculates start dates for 5 project phases that need to happen before the finish date. Each phase takes 1 month, therefore phase 1 starts...
  8. S

    Percentage Complete List/Line Graph that automatically updates when a certain date is reached.

    Hey All! Is there a way to have a formula run(in my case a countif function) on specific dates each month for a period of a year? Can't find any info. The dates aren't filled in yet, and I am wondering if there is some DATE function that can run itself when the date occurs(like 5/1/2021). I have...
  9. P


    Hello, I am trying to convert a date with a timestamp into a date value. However, although I tried multiple approaches, like using INT(A2), the value is still not recognized as a date value. And the weird part is that some of the original values are working as a date value when I copy/paste to...
  10. G

    Formula to Determine How Many Days From a Specified Date Range Appear in a Different Date Range?

    Hi All, I have a list of events with start date and end dates (sometimes these are single day events) but I need to know how many working days appear in a certain month. For example someone has taken a holiday from the 29th of January to the 5th of February 2021 this is 6 working days but only...
  11. B

    Average, Large, Date Range question

    Hello, I am calculating a weekly score for number of steps performed. I'm taking the top 5 days out of the 7 days in a week using this: =AVERAGE(LARGE($B$2:$B$8,{1,2,3,4,5})) The NO HOLIDAYS table in my spreadsheet is working perfectly. The HOLIDAYS table is just a copy of that table which...
  12. A

    Find a Date when "d" formated

    Hi, I have one excel sheet with the date 30/01/2021 custom formated with "d" to show me only the day (30). When I try to find the same date, in the format 30/01/2021, with "Find and Select" I get the message: "We couldn't find what you were looking for. Click Options for more ways to search."...
  13. S

    Find the Matching Date and Copy Rows to Another Workbook

    Hello, I have been trying a variety of methods to get this to work and none of them seem to work. I have a date on my worksheet that populates with today's date. If the value in sheet DataMaintenance, column G matches today's date (can be provided in a cell), I'd like the information from...
  14. Brett Fields

    Help... I need some sleep!

    Every day I produce a spreadsheet (not of my own design) to report on the vaccination of our workforce. It needs to be out by 7:30 a.m. The raw data is available at 10pm the night before in 4 CSV files. I have 1 macro that imports the new info onto a sheet called "Data", and another macro that...
  15. Jyggalag

    Neutralize/reset "info", "properties", "related dates & people" in Excel/PowerPoint

    Hello everybody, I am currently looking at excel/PowerPoint, where you have the following when you open a document: In the cases above, I have simply opened a blank document. However, what annoys me is that if I use a template from any prior documents, it will say the names of the authors...
  16. D

    Power Query - COM-Error due to month & year extraction from date

    Hello everyone. For some reason, I keep getting an error, when I try to add two columns (year and month) based on the value in a "date" column. The error appears once I try to establish a "Data-connection" and add the data to my Data Model. I apologise for the language below being in Danish...
  17. M

    Sort list by date, expanded selection?

  18. F

    Store Date in Cell When Another Cell Changed

    Boy am I glad I found this forum. I'm hoping some of you can help a novice out... I have a file that tracks supplies and therefore has a sheet for each of our office locations (a total of 30 or so tabs/sheets). Every Monday the Admin for each office needs to review their sheet and adjust the...
  19. K

    Average over Last 90 Days - Multiple Sheets

    I have created an example version of the spreadsheet I am attempting to create. Each months sheet looks like what I have posted below. I am looking to use one of these sheets each month. I would then like an analysis tab where I can look at; -Overall Average of "Test Scores" - (I can and have...
  20. N

    Date Input Expression Builder

    Hello, I am trying to create an expression that will control a users date input in reference to a pervious field. This is what I currently have: [Field 1]<=[Field 2]<=[Field 3]<=[Field 4]<=[Field 5] Field 1 has an expression/Validation rule of: <=Now() Essentially, I want the first field to...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back