date & time picker

Hello all: I want to track and chart the total number of days per month several pieces of equipment are out of service. The insert is just a idea on how I may go about this, it may be inefficient or even not doable, so its not set in stone. I have a start date and an end date that each...

I have a workbook where a lot of employee data is updated monthly, screened for compliance, and reported. Since it is updated monthly the data obviously changes from month to month. However, I want to build a new sheet that tracks the trends from month to month, that is automated when the report...

How can I have dates be on 8 Week rolling data but always start at a Monday? For instance this is what I did to get it to start from 8 weeks ago: But I would want it to actually start on 5/2/2022 because that was the Monday of that week.

Hi, I have a lot of remote camera data, and I would like to calculate the working hours of each camera in each season. I divide a year into two seasons: the breeding season (Apr - Aug), and the non-breeding season (Sep - Mar). Column J (Working hours) shows the total working hours, which are...

Hi, I have thousands of lines of data across several months in the following format: item Date Result A 1/2/20 Attention A 1/24/20 Attention B 1/25/20 Passed B 1/24/20 Passed B 1/24/20 Passed A 1/24/20 Failed A 1/25/20 Passed C 1/25/20 Passed C 1/25/20 Failed C 1/25/20...

Hi! I need users to enter a date into Excel cell. However it needs to be in a controlled, but user-friendly manner. So, I can't just let users manually edit the field for date formatting problems as well as typos. I'm thinking of some nice graphical calendar view perhaps. I have another...

Dear All, I was trying to add a date picker on my userform and I installed Sam Radakovits Date Picker Excel Date Picker — Sam Radakovitz. In the end I've never used it because I don't like it and also because I don't want to install it on all the PC of the users. My project worked on any...

Hello guys, I need to change the date from one application but I don't know how. The inspect page is attached. Here is my code so far: Dim MyElement As UIAutomationClient.IUIAutomationElement Dim MyElement1 As UIAutomationClient.IUIAutomationElement 'Private Declare Sub Sleep Lib...

Hello, I am having a very strange issue where I select two dates (in the format mm/dd/yyyy hh:mm:ss) and a table is generated with data from the Start Date and End Date. There is a 'data storage' sheet, Sheet4, that has all potential dates to choose from in Row 4. There are 5 columns of data...

Hi Guys! Happy Friday! (for people in time zones 0+10/0-10) haha :) I usually like to come to the board with something I've had a go at myself first, to at least bring a starting point! this time though im looking for abit of advice and help id like to put a date selector in a cell that has...

Hi Friends, I am trying to choose a date from webpage, by date picker calendar and fortunately reached for a mile with my current code, _________________________________________________________________________________________ Driver.FindElementById("validtill").Click d = Sheet1.Range("BA2") n...

Hi, I need to reference the specific site name on column B, find out which entry for that site is the most recent from column A and return the value in C (whether it is "cleared" or "raised"). There will be duplicates in Column B (Source) but I am only interested in what the most recent...

Hi all. I hope you can help. I have a date picker that pops up on column H as I wanted to standardize how dates were entered on the the Excel sheet. The issue I am facing is that if I or any of my team based in Dublin click on a cell in column H from Cell H10 down then the date picker pops up...

I hope you can help. I have a piece of code. Essentially what it does is, it opens a dialog box that allows a user to select an excel sheet, then it goes out to the country column (11) filters it, then copies and pastes that country into a new workbook, names the new workbook after that country...

<colgroup><col span="3"><col></colgroup><tbody> A Cloumn` B Column C Column D Column Good 52 1 4/12/2017 0:00 Good 53 1 4/12/2017 0:00 Good 4234 1 4/12/2017 0:00 Good 5232 1 4/12/2017 0:00 Good 42342 1 4/12/2017 0:00 Good 24442 1 3/30/2018 0:00 Bad 41233 0 4/12/2017 0:00...

Hi All, I have struggled over the years to keep date formats consistent with users over 4 continents, 4 different languages and (of course) for different language OS'. I developed a simple date form that I'm using to that end. I thought I'd share it with you, who have been so helpful to me over...

I just installed the Microsoft Date and Time Picker Control 6.0 (SP6) onto my Excel 2013 (32 bit). However, when I place it on my worksheet, something strange happens. To place it I perform the following steps: Developer tab Insert ActiveEx more options Microsoft Date and Time Picker Control...

Hi I have a spreadsheet that I developed on a Windows 7 (64-bit) PC in Excel 2007 (32-bit) with the DTPicker control in a userform. This worked fine but I then shared the spreadsheet with a friend who has a Windows 8 PC (32-bit) and Excel 2010. I am getting a "Compile error: unable to find...

Hi, With the help of others' posts I've managed to insert a pop-up date & time picker (Calendar1) that gets activated whenever I select a cell within specific columns (Case Target.Column). My problem now is that whenever I am working with any other cell not within my Target.Column I would...