+ Reply to Thread
Results 1 to 6 of 6

Workday Formula and Calendar

  1. #1
    Registered User
    Join Date
    09-15-2020
    Location
    Seattle
    MS-Off Ver
    Office 365
    Posts
    3

    Workday Formula and Calendar

    I've created a calendar for my students but I'm having an issue with one of the formulas. I go to tab PART 1 Enter Planning Dates and enter dates into cells A8 to A43, the A4 cell in the Part 2 tab turns into a duplicate of A3.

    Any help would be amazing because I have been looking over the formulas for weeks and nothing sticks out.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    Office2010/office 365
    Posts
    2,192

    Re: Workday Formula and Calendar

    Dont see the duplication you are talking about...please explain

  3. #3
    Registered User
    Join Date
    09-15-2020
    Location
    Seattle
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Workday Formula and Calendar

    For example, if you go to tab PART 1 and change A16 from 12/28/2820 to 12/28/2020 then go to tab Part 2 and look at A3 & A4. They will now have the same date.

  4. #4
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    Office2010/office 365
    Posts
    2,192

    Re: Workday Formula and Calendar

    It's becuase of your column I that is hidden in "PART 2 Course Information" . why dont use whole numbers ?

  5. #5
    Registered User
    Join Date
    09-15-2020
    Location
    Seattle
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Workday Formula and Calendar

    The number for Column I is based off a formula. I added Round to the formula in the I column and it appears to solve it. Thanks for the help! This is my first post so not sure how to mark it solved.

  6. #6
    Forum Contributor
    Join Date
    10-05-2017
    Location
    Altamonte Springs, FL
    MS-Off Ver
    Office 365
    Posts
    143

    Re: Workday Formula and Calendar

    Go to Thread Tools in the light blue bar above your post. Drop down to Mark as Solved.

+ 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] IF WORKDAY Formula - where to add WORKDAY?
    By McCaughley7 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-30-2019, 12:56 PM
  2. [SOLVED] How can I calculate workday date when only have calendar days?
    By Tooley in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-03-2017, 09:31 AM
  3. WORKDAY Formula
    By Simoin in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-05-2014, 08:32 AM
  4. Workday.INTL or Workday function issue
    By junoon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2013, 03:14 PM
  5. Workday Formula to Calendar Day Formula
    By tgause in forum Excel General
    Replies: 3
    Last Post: 06-04-2010, 07:53 PM
  6. Workday formula
    By 3daluminium in forum Excel General
    Replies: 5
    Last Post: 04-22-2010, 02:26 PM
  7. How can I specify workday capacities in a dynamic calendar???
    By beb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-07-2005, 03:05 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