date

Good morning, I'm having a hard time trying to figure out a macro that will update the yyyy-mm(+1) in a specific cell. It needs to include the ' at the beginning as that year-month is used to update the table below it. Example: It is currently September 2022 right now. I would need the macro...

Hi, I have a column with various dates in it (column AK). Scenario: Today's date (Tuesday 13/09/2022) if date in AK2 is between Monday 05/09/2022 and Friday 09/09/2022, then return the value of "Yes", otherwise "No". So next week the Monday's date would be 19/09/2022 and the previous Monday...

Hi all Ive had a look through the discussion board and cant quite find what i was looking for, or the codes were very different. The idea is a macro button which saves to a specific location, saves as a PDF, saves name as todays date. Please find code below. Currently it is saving the PDF in...

I've made a (really neat, and tough to write!) formula that evaluates a single date against a single cell's value, where that cell contains multiple date ranges, and then indicate whether or not the date is within any of the listed multiple date ranges. The multiple date ranges are formatted in...

I have a set of data that is formatted one way (including multiple items in a single cell), and I want to extract that data and display it a different way (each item in its own cell, in a column). The data is always changing, so I am looking for a formula that will auto-update as new rows are...

Hello I'll try and keep this simple. Sheet 1 This is a list of absence. Each separate occasion of absence is recorded against a unique employee ID in Column A and on it's own row. On each occasion, there is an absence start date and an absence end date. Example: an employee with 2 separate...

I have a checklist I want to fill the dates - Monday to sunday and also fill the week ending date too. I then want to print the sheet for the entire month. For example, 01/08/2022 -07/08/2022 in the "Mon to Sun" boxes (C3-I3) and then 07/08/2022 in K1. And then have this repeat for each week...

Hi! I am desperate. I purposely registered just to ask this question. Hope you can help. I have a shared file in server. I change all date values to dd/mm/yyyy format. But every time another user opens it, the format becomes d/m/yyyy. I prefer dd/mm/yyyy so all numbers are aligned. How do I...

Hello I am trying to calculate and then chart the difference between dates in a pivot table and I could use some help. I have a list of dated transactions for various customers and I am trying to find the time elapsed since the previous payment so that I can show it in a stacked column chart...

Ok new user here. There have been a few posts about clearing parts of the excel by a date. Tried some but have not helped me sadly. Let's say i got a timetable, i want to trim it with a button, and in column E i got the date (2022-07-24) for example formatted. and in column F i got the time...

Hello everyone, I'm using the below formula to populate a cell with today's date when the adjacent cell contains data. =IF(ISBLANK(B164)," ",NOW()) Can anyone confirm how to adapt this formula so that upon entry of the date is becomes 'locked', meaning that when the sheet is opened the...

Hi there, anybody can help me with the date comparison? I just want to compare two dates then i wanna know if date in colum B exceeds date in colum A for a month and 3 months. if true just put a text on colum C. ABC115/12/202215/01/2023EXCEEDS FOR A MONTH215/12/202215/03/2023EXCEEDS FOR 3...

I have a formula to show when a given date was in the past and how long ago it was but I need it to display when a date is in the future as well rather than returning #NUM, if possible just saying "Future" would be fine. The formula I'm using is...

Hello, I have a Excel sheet in which dates are in this format : YYYYMMDD without "/" separation, So I used "Record Macro" - DATE -> Convert to change in to this format : DD/MM/YYYY, here the code it got me out : Range("A5", Range("A5").End(xlDown)).Select Selection.TextToColumns...

Hi all, Can I know how to get month in “mmm” format if I have a date in its previous column. For eg: column A contains date in short format. I want column B to show only the month in “mmm” format based on the date in column A. Similarly column C will show only the year in “yyyy” format. How to...

Hi, Can someone help me on my below issue please. I've my data from Col A to F. Trying to remove duplicates from Col A to D and copy the non duplicate data in to E with a delimator. Now the issue is whenever I run the script, the first 12 days of any month is converted from dd-mm-yyyy to...

Hello, I have a task to generate a sheet containing following headers : Part Number, Quantity, Date The quantity to be produced is given in one more sheet and that quantity needs to be distributed in that particular month. For example: In the vba code, it has to refer the particular month...

Hi, I'm trying to calculate the finish date and time of a production run but excluding hours the factory doesn't work. I have the start date + time and the production hours needed, please help!!!!!

Hi All I really need your help. I have an inventory in and out log. It logs date an asset was issued and date it was returned. I have everything in a drop down menu and i need the following. these assets are loaned out on a daily basis and returned on a daily basis. (Or supposed to be) there...

Is there a formula (not autofill) this scenario - I manually enter a month (lets say, March) into cell F2. Now I want to add a formula into cell M2 that will recognize F2 says March, and put the next month, April, in cell M2 where the formula is. I do not want the full month/day/year - only...