Results 1 to 8 of 8

[Solved] Calculate End date with Start date, Training hours and Based on Working days

Threaded View

  1. #1
    Registered User
    Join Date
    03-06-2020
    Location
    Singapore
    MS-Off Ver
    2016
    Posts
    4

    [Solved] Calculate End date with Start date, Training hours and Based on Working days

    Hi, would appreciate if the experts here can advise whether it can be done with a formula if I need to calculate a training end date based on below available info.

    A) Number of approved training hours
    B) End date should be calculated based on number of working days per week, which could be 5,5.5 or 6 days.

    I have attached a sample data and would appreciate very much if anyone could help please.

    Thank you
    Attached Files Attached Files
    Last edited by Nelson Ong; 03-06-2020 at 08:17 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculate start date & time of task (working hours)
    By kaaver in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-30-2016, 10:56 AM
  2. Calculate start date from finish date minus 14 working hours
    By PietBom in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-08-2014, 07:23 PM
  3. [SOLVED] Calculate END DATE based on START DATE & No of working days
    By prashantha in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-20-2013, 07:22 AM
  4. Replies: 0
    Last Post: 03-21-2013, 12:22 PM
  5. Replies: 0
    Last Post: 09-13-2012, 05:28 AM
  6. Calculate START date based on duration (work hours) and END date
    By kaaver in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-06-2010, 12:21 PM
  7. Calculate start date based on working hours and end date
    By kaaver in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-28-2010, 06:58 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