date and time picker

  1. samrad

    Updated Date Picker Add-in For Excel

    Hey! I made a date picker a while go but just recently refreshed it so I wanted to share it with folks! I think there are a few add-ins that do this already, but I wanted to try and make one a bit more modern looking and use a few extra features like mouse wheel to navigate. It adds a button...
  2. R

    Exclude Weekends

    Hi Excel guru's. I have have to track orders that must be completed within a certain date range, e.g. within 90 days of create date. A simple formula of can address what the expiration date would be, however often these expiration dates land on a weekend. Simply using a =WORKDAY() is...
  3. R

    Splitting dates not working

    I have been bashing my head against this problem for a few hours and just when I thought I'd cracked it running some validation against the formula showed it adds up 1 year as 364 days so I have just shifted my problem. In short I have two dates 02/11/2013 and 04/06/2014 and I need a formula to...
  4. E

    Customisable drop down calender

    Hi, I am trying to create a cutomisable drop down calender. The only option i have found so far is "microsoft date & time picker control 6.0 (sp4)" active-x control macro. However so far I cannot seem to customise the dates it allows me to select. I need it to only allow every second...
  5. K

    ActiveX control screwup needs correction (old version of date picker and month view .ocx)

    During the course of a VBA project for work I needed a date picker control of some kind. I failed to see one in my home PC (all Pcs involved are running Excel 2010) so I discovered the MonthView control online, which I also failed to notice in my "additional controls" list. I now realize...
  6. P

    Search for date in Listbox

    Hi Guys , I have code that will look for any value in a Textbox and displays them in a listbox which works fine but I am having problems trying to find DATES using a the Datepicker "Drop down calender" when I Select a date and press the Find button I set up? I get no result what so ever, not...
  7. D

    Date and time picker control - easier way to install

    Hello All- I use this forum all the time for information, but rarely post questions.. That may change as I'm working on a project that is perhaps slightly above my ability. Here is my problem: I'm building a custom user form that relies heavily on the Date and Time Picker control (MSCOMCT.OCX)...
  8. J

    Need Scroll VBA code to use with Microsoft DT Picker control

    Using Excel 2010, I am using the Microsoft DT Picker control on certain sheets within my workbook. The workbook is setup to automatically open on sheet "Start" regardless of which sheet the workbook was last saved on. When reopening file and I select a sheet that utilizes the DT Picker control...
  9. S

    Date/Time/Calendar Control to work in multi Excel platforms (2003/2007/2010)?

    Need a Date/Time/Calendar Control to work in multi Excel platforms (2003/2007/2010) please... So... I have several spreadsheets created using Excel 2007 with 'Calendar Control 12.0' controls in them. It wont work in Excel 2010 as that control was removed from Office 2010!!! Now... I also...
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

This Week's Hot Topics

  • link pictures from Sharepoint to Excel macro
    Hi, I need your help to fix this issue. I have a code and this is work on my computer. But now I try to link the picture from the SharePoint to...
  • lookup match return closest to x date
    Hi all, Happy New Year, this is my first post in 2022. I have two worksheets I'm working with. worksheet one is titled KPI Data - MY22 ONLY It...
  • Average hours per week
    I'm trying to find a simpler/quicker way to obtain the average number of hours per week for employees. My spreadsheet contains columns for Date...
  • Google Sheets IMAGE Function
    Is there any way to replicate the IMAGE function from Google Sheets in Excel? Maybe a VBA code? From what I can tell, the function in Google...
  • Identify equipment used -No of consecutive days
    Hello, I appreciate your time and effort. I would like to have formula for column O and P. Column A : lots of Asset Column C: date If one Asset...
  • Filling in data from source
    Hi All, I'm not quite sure what to call the following type of data manipulation so I don't quite know how to phrase my question. Below is an...

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
Top