+ Reply to Thread
Results 1 to 4 of 4

Update a date

  1. #1
    Registered User
    Join Date
    07-28-2015
    Location
    USA
    MS-Off Ver
    '07
    Posts
    2

    Update a date

    prolly a easy fix but can I make a macro or something so that when I click a button, it changes the date by a certain number of days?
    Capture.PNG
    Also, is there a way to make a conditional format based off a different worksheet?
    Thanxxx

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Update a date

    Attach this code to a button

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    07-28-2015
    Location
    USA
    MS-Off Ver
    '07
    Posts
    2

    Re: Update a date

    Thanxxx that worked great

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Update a date

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks for the rep.

+ 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. update date to 10 days after another cells date
    By tabford in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-19-2015, 07:23 PM
  2. [SOLVED] Auto Date update to replace old date in data sheet via userform
    By Raylou in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-27-2014, 12:18 PM
  3. Replies: 2
    Last Post: 10-13-2014, 02:11 PM
  4. Date Format Of User PC Changes Display format date of Excel File after update
    By waihar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2014, 03:09 AM
  5. How to update Text Box with date 14 days after selected date...
    By mjc61 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-25-2014, 08:10 PM
  6. VBA to update pivot tables date between value - Date error
    By delboy2405 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2013, 01:46 PM
  7. [SOLVED] Macro to update pivot item (date format) in pivot table to latest date from data source.
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2012, 03:18 AM

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