+ Reply to Thread
Results 1 to 1 of 1

Date Picker and preset dates

  1. #1
    Forum Contributor
    Join Date
    08-04-2013
    Location
    Bucharest
    MS-Off Ver
    Office Professional Plus 2019
    Posts
    303

    Date Picker and preset dates

    Hi, in the attached file, I am using two date pickers (starting and ending date) to select a period of time, the date pickers are linked to Q2 and Q4 cells, and the formula in the O column is looking at the dates selected by the date pickers to establish if the date in the D column is within the required period or not.
    What I am trying to do is to have a button with preset dates, so that if I will press the "last 12 moths" button , the Q2 and Q4 cells will be set at TODAY-365 and TODAY, for example. I have tried to use the TODAY function directly in the cells but the formats aren't matching with the current ones. If there is another way to do this I'm open to suggestions.
    Ty for your time.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Date picker don't display current date
    By Adventure_Harry in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-19-2013, 11:45 AM
  2. Replies: 7
    Last Post: 12-08-2013, 06:11 PM
  3. Extract From date To date using DTP picker activex
    By thameem127 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-28-2012, 04:22 PM
  4. Date Picker won't select current date: Userform
    By valkok in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-04-2011, 06:09 PM
  5. Date Picker Control will not display Current Date
    By SP Brian in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-04-2011, 01:33 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1