date

  1. G

    Auto Update data weekly help

    Hi I am stuck and need some help please. I have attached a picture of the issue i am having. Basically i have 7.5% in the red box (Cell B2) that i have to update manually. I would like it to auto update each Tuesday of the month with the same % as the week before (orange box's) but if say on...
  2. H

    Selecting most recent date in slicer VBA

    I'm stumped on this one - I'm currently automating a file and I need the macro to select the most recent date slicer dynamically. My current code is selecting all of the dates listed in the slicer instead of the most recent date. Sub maxdateslicer() Sheets("FIP").Select...
  3. C

    Points fall off after 365 days

    I am attempting to get absentee points to fall off after 365 days. My sheet has a row with the date. A row with the points. I have it totaling the points in the row but want the points to not be included if its been 365 days. My formula does not work...I have attempted multiple variations with...
  4. G

    Conditional Formatting for Various Dates

    I am trying to figure out formulas to create conditional formatting for dates that take into account the current date and its relation to future dates, and that are not limited to specific months, years, or number of days. I would like these formulas to be able to carry over into future years...
  5. M

    Locking cells / rows after a specific date. VBA?

    dear all, I'm currently stuck with Excel and I hope you guys can help me. I am looking to lock specific rows (in the screenshot: the forecast quantity) D6-O6, D9-O9, D12-O12, D15-O15, etc (until D24-O24) after a specific date has passed. This date will be defined in D3-O6. So the way it...
  6. M

    Convert Date Problem

    Hello, I'm facing the following problem: I insert in 2 cells: month (in text) and year (in number) (example. "October" and "2024"). I want to create a function that convert this information in the following format "dd/mm/yyyy" and print it into a specific cell. I tried myself for a lot of time...
  7. B

    Macro code changing date format

    Hi to all of you, I have an excel sheet with an Inputbox, where i'm asker to put the number of the month, the year and a third value. Problem is, it was working as intended during 2023, but now, it's swaping the month for the day. I'm in Europe, we use dd/mm/yyyy and I'm trying to make the...
  8. Z

    Dynamic Working and Week days remaining until end of month from a specific date in the month

    Hi, I have dates with 14 days difference between them (employees paid every 2 weeks). Is there a way to automate the Working days and week days to the end of month from the last pay date. I am currently doing this manually using calendar which is open to errors and time consuming. Basically...
  9. charlesstricklin

    Add ordinal to date

    I'm stumped. I have a column B which has dates in the format "Wednesday, March 15, 2023". I'd like the cells in column C to show a date like that as "Wednesday, March 15th, 2023"
  10. 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?
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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.
  18. 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...
  19. 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...
  20. 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...

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