+ Reply to Thread
Results 1 to 3 of 3

Help with making a mm/dd/yy format based off of another formula

  1. #1
    Registered User
    Join Date
    07-20-2017
    Location
    milwaukee, wisconsin
    MS-Off Ver
    2010
    Posts
    11

    Help with making a mm/dd/yy format based off of another formula

    I have a calendar that I am working with in Excel and i need to make a row that shows the mm/dd/yy for the day so that i can use that in other formulas.

    This is the template I am working with
    calendar.PNG

    The formula that populates the automatically updating days (dependent on the calendar year) is =IF(DAY(JanSun1)=1,"",IF(AND(YEAR(JanSun1+1)=CalendarYear,MONTH(JanSun1+1)=1),JanSun1+1,""))

    How can I take this formula and populate a mm/dd/yy format in a row above the days that also automatically updates like the current formula?

    Thanks in advance!!
    Last edited by jriemann; 07-28-2017 at 10:31 AM.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: Help with making a mm/dd/yy format based off of another formula

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    07-20-2017
    Location
    milwaukee, wisconsin
    MS-Off Ver
    2010
    Posts
    11

    Re: Help with making a mm/dd/yy format based off of another formula

    Quote Originally Posted by Norie View Post
    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Ok so this is the file im working with. trying to generate a calendar that shows the testing schedules displayed in the 2017 sheet
    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. [SOLVED] Making a format as a genuine value
    By kmsalehi in forum Outlook Formatting & Functions
    Replies: 13
    Last Post: 05-30-2020, 12:55 AM
  2. [SOLVED] Need Help! Formula Based Number Format
    By WooText in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-04-2017, 05:34 PM
  3. Formula based on cell format
    By Wizards in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-24-2015, 08:13 PM
  4. How do i calculate a formula based on a time and making money due.
    By Joel10952 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-18-2013, 12:44 AM
  5. Making my own Category under Format Cells...
    By tenswmmsc in forum Excel General
    Replies: 3
    Last Post: 07-16-2010, 12:46 PM
  6. Making the user be able to format a text box
    By gruebz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-08-2007, 04:52 AM
  7. Making a number have Text format
    By Howard Kaikow in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-06-2006, 11:30 AM

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