date

  1. charlesstricklin

    aturday, March 16th, 2024 to MM/DD/YY?

    I give up! I've been trying to convert a date, say A2 as Saturday, March 16th, 2024 in a text format, to an actual date in the format of MM/DD/YY? P.S. Better yet, how to convert date in two cells, say B2 and C2 containing the month, i.e. 3 in the example above, and 16 also in the example above?
  2. Akuini

    Excel VBA: Function to Obtain Correct Date Format When Converting Text to Date

    Dealing with dates in VBA can be a bit tricky. When attempting to convert a string to a date, we may encounter unexpected results. The issues typically arise in the following ways: - The day, month, and year might get swapped or changed unintentionally. - What we typically consider as an...
  3. J

    Adding Large Numbers and Dates together results with incorrect sum

    Hi Forum, Can someone please validate that this is an issue I have a column with large numbers stored as text (ex. 10000001000012) and I am concatenating a date column (ex. 45265) into a larger number: 1000000100001245265 Now if i evaluate this concatenated number with the VALUE() function...
  4. W

    Filter Function based on a date nested in Xlookup

    Hi, See attached a sample job scheduling dataset. I need to lookup the bay # and return the job # which is simple enough with an xlookup. However, there will be multiple jobs with the same bay # and I need a way to be able to only pull the job number that starts after a certain date. I would...
  5. D

    Open Certain Worksheet Based on Current Date

    Hello everyone! Back in 2018 you guys helped me with some VBA code that would set the color of a certain tab in a timekeeping/pay period workbook depending on the date. (see Tab Color Dependent on Date) With a few tweaks over the years, the code used in the solution has worked flawlessly over...
  6. D

    How to automatically replace Excel formula with value when date condition is met

    Hi, I have been trying in many ways but I have not been successful to record the results of a constantly changing cell. Value changes daily and depends on other variables external to the problem. This is the case: Cell A1 value is changing, and I need to record the value of A1 at specific...
  7. D

    I Can Only Group Dates by Selecting all Cells, not Single ones. Dialogue Box Won't Pop Up

    Hi Everyone, I'm having a date grouping issue. I can group dates in my Pivot table by selecting all dates. As soon as I try doing it by selecting a single cell it says "Cannot Group Selection." I've reformatted the data multiple times and refreshed the Pivot table. Still no luck. Any advice...
  8. A

    Lookup Horizontal and Vertical Date and FX Rates

    Hi, Would you please help me with the following need: I want to retrieve FX rate from "list of FX" according to currency type and date to highlighted yellow column. Apologies for not proper excel data. At work it is not possible to use XL2BB. Thank you very much for your help in advance.
  9. S

    Return Text based on Max Sum of number values by month

    Hi, This is for Excel. I need a formula that returns the text when using a sum max for a number by date. In the below example, AA02 is the answer for January 2023 b/c 4,120 is the max sum (3,995 + 125). cell A1 1/31/2023 2/28/2023 Result AA02 CCC data set Month Year SKU total...
  10. C

    How do I do conditional formatting with today's date, but which also includes other text?

    Hi guys, I've been trying to find a way to adopt conditional formatting for a cell which contains today's date. I've been able to do this successfully, but if I include other text in the cell (for example, a time - see image attached), the conditional formatting does not work. What would be...
  11. G

    Parse dates into comma delimit values

    Greetings Excel Community, I have a set of data and i am wondering if there is code or formula that can be created to parse these values into comma delimited dates. The dates are combined together to make it look as a long string, however i am attempting to create the end result under the...
  12. L

    Perform operation if today is the first of the month VBA

    Hello, I'm building a macro that will perform a data pulling operation each day when I run it. This part of the macro runs great. But, at the start of each month the data should be scrapped and the data storage worksheet should start again from zero. The idea that I have is to bracket my...
  13. E

    Extract cell content into separate columns

    I've got a data set of 6,133 rows with cells of dates in the following format: Cell A1: Status A-2022-02-03; Status B-2022-03-11; Status C-2021-09-10 This is an example of the content in a given cell and I want to separate the statuses and their respective dates into separate columns (by using...
  14. G

    Split items into Rows

    Greetings Excel Community, Below I have some Test data where the Unique ID has a relationship with the "Value" column. For each UniqueID, there must be a corresponding row from the "value" Column. What I am trying to accomplish is a formula or VBA Script that will split the UniqueID into its...
  15. N

    2 QUESTIONS - DATE SEARCH AND OUTLOOK CALENDER

    Hi all, I am very new and very inexperienced, I hope someone can help me. I have 2 questions see below first one: I want to find duplicate dates for my database, but not working. I want to show how many duplicates too. Private Sub Textbox3_afterupdate() Set rng = Range("E2:E3000") Dim ws As...
  16. H

    Display month based on calculations

    I need a formula that will display “if a selected date +21 days is at least 30 days from the 1st of the next month, then display the next month. If less than 30 days from the first of the next month, then display the next month + 1 month.” For example, if a selected date is 9/11, then 21 days...
  17. Z

    VBA: Select Range in Current Week

    Hello, I'm trying to figure out how I can select a range based on a date within the current week. Example of selection… The order I'm trying to step through is the following: 1. Declare Friday as a variable to store the date using a formula: =TODAY()-WEEKDAY(TODAY(),16)+7 As of today...
  18. H

    Group and UnGroup columns based on user input of a current date

    I have a spreadsheet that have pay period dates, that run from V5 to AT5. We have the past pay months within 1 month grouped together and the future months within 1 month grouped together. For instance this month is August, so all the columns with dates in July, August, and September are not...
  19. R

    Excel spreadsheet- Date issue

    Hi all, I have a very large spreadsheet with value dates for each row, I normally filter it by dates and also use the “newest to oldest” filter but for some reason my dates are not formatted correctly so some are not included in the year drop down and instead are separate to the other dates...
  20. N

    Excel Macro how do I filter time using VBA to copy/paste to different sheet

    I'm trying to use VBA to automate a process I perform multiple times a day. I've figured out a little bit but I've got 2 different columns containing time. The estimated time is sometimes populated so I want to be able to filter on 2 conditions: either ET (Estimated Time) is populated and...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top