+ Reply to Thread
Results 1 to 2 of 2

Creating a dynamic monthly meal calendar

  1. #1
    Registered User
    Join Date
    04-28-2021
    Location
    United States
    MS-Off Ver
    2019
    Posts
    2

    Creating a dynamic monthly meal calendar

    Hello all! I am new to the community but I am looking for some assistance on a spreadsheet that is a bit beyond my excel knowledge. Any help is appreciated.

    I am attempting to create a meal calendar that automatically updates from a tab that includes a list of daily meals for a complete month (see Meals tab on the attached spreadsheet). Making the calendar match the meals tab was easy enough with the following formula, =VLOOKUP("4/7/2021",Table1[[DATE (TEXT)]:[LUNCH]],2,FALSE). The part I am having trouble with is automatically adjusting to the position of the days. For example, when changing from April to May the 1st of the month moves from cell F6 to H6 and that is where my formula knowledge drops off. I am not sure how to incorporate the tracking of the day, month, and year to always have the correct meal.

    Any help is greatly appreciated. If there are any questions please ask.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Brunheas; 04-28-2021 at 09:34 AM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,209

    Re: Creating a dynamic monthly meal calendar

    See if the attached helps: see sheet "Actvities"

    Originator is "Pete_UK" (not myself)

    See April
    Attached Files Attached Files
    Last edited by JohnTopley; 04-28-2021 at 11:11 AM.

+ 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. Replies: 1
    Last Post: 06-29-2017, 02:11 AM
  2. Creating a Semi-Monthly Payroll Calendar
    By dvanallen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-06-2014, 08:39 PM
  3. Creating meal plans using formulas
    By evaudio in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-07-2014, 10:03 PM
  4. Replies: 3
    Last Post: 07-29-2014, 01:20 PM
  5. Want to recreate "Monthly Meal Planner" template
    By henpen in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-31-2013, 09:19 PM
  6. Help creating Dynamic Calendar
    By dctr_mas in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-29-2013, 08:51 PM
  7. Modify Yearly Calendar to Monthly Calendar Excel 2000?
    By James Cooper in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-13-2006, 06:50 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