+ Reply to Thread
Results 1 to 5 of 5

changeable date from tab one auto mark on a calendar in tab 2

  1. #1
    Registered User
    Join Date
    04-14-2021
    Location
    USA
    MS-Off Ver
    365 office
    Posts
    3

    Question changeable date from tab one auto mark on a calendar in tab 2

    Good Morning,

    I've been trying to find a way to for Excel to automate changes made on placed in service dates on a calendar for an easy look. Our placed in Service dates effect an abundance of department's workloads and I am hoping to create a better way for everyone to track changes. Is this possible? Please see attached example.

    If I change the date in F2 from 5/30/21 to 6/30/21, I would like for it to reflect that change on the calendar on tab 2, moving the numerical value of 36 from G4 to H4.

    Thank you!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    19,813

    Re: changeable date from tab one auto mark on a calendar in tab 2

    I did a few changes so the following formula can be used:

    in C4

    =IF(TEXT(BLD!$F2,"mmm")=C$2,INDEX(BLD!$G2:$G$100,MATCH($B4,BLD!$A$2:$A$100,0)),"")

    Months in row 2 all 3 characters.

    Data in column B needs to match that in A in "BLD"
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-14-2021
    Location
    USA
    MS-Off Ver
    365 office
    Posts
    3

    Re: changeable date from tab one auto mark on a calendar in tab 2

    Great! Exactly what I was looking for, thank you so much!


  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    19,813

    Re: changeable date from tab one auto mark on a calendar in tab 2

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

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

  5. #5
    Registered User
    Join Date
    04-14-2021
    Location
    USA
    MS-Off Ver
    365 office
    Posts
    3

    Re: changeable date from tab one auto mark on a calendar in tab 2

    Thanks for your help, I will solve it now. I did add to your reputation already

+ 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. [SOLVED] Auto Populate Date Ranges to Linear Calendar
    By ohlrie5b in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-21-2021, 02:28 PM
  2. Graph with changeable date axis
    By Scott Bolton in forum Excel General
    Replies: 2
    Last Post: 04-24-2019, 06:52 AM
  3. insert changeable date for a lookup to different worksheet
    By Gordo17305 in forum Excel General
    Replies: 1
    Last Post: 08-03-2018, 12:43 AM
  4. [SOLVED] How do I Auto Populate a Calendar Series per Start and End Date?
    By Inez15 in forum Excel General
    Replies: 3
    Last Post: 11-13-2012, 04:05 PM
  5. Help in making a calendar with option to mark against each date
    By Parv in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-20-2012, 05:53 AM
  6. Replies: 0
    Last Post: 07-03-2012, 03:52 PM
  7. Auto creating a calendar based on a date in a cell.
    By avidcat in forum Excel General
    Replies: 4
    Last Post: 12-30-2009, 04:12 PM

Tags for this Thread

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