+ Reply to Thread
Results 1 to 3 of 3

Date formatting

  1. 05-01-2021, 09:20 AM #1
    chris8877
    chris8877 is offline
    Registered User
    Join Date
    10-03-2012
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    55

    Date formatting

    In the attached sheet, in column 5, please recommend me a formula to get finish date same as shown in column 4, when add duration and start date. Currently I am getting error in column 5 due to duration.
    Please advise.
    Regards
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-01-2021, 09:39 AM #2
    Limor_OP
    Limor_OP is offline
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Date formatting

    Hi
    I Added 2 columns for weeks/days
    in H:

    =(E3+C3*7)+D3

    Are you sure your manual results correct?
    Attached Files Attached Files
    Last edited by Limor_OP; 05-01-2021 at 09:42 AM.
    Reply With QuoteRegister To Reply
  3. 05-01-2021, 09:58 AM #3
    Czeslaw
    Czeslaw is offline
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,296

    Re: Date formatting

    Formula
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional Formatting for Gant Chart based on : Start Date / End Date / Status
    By Stancur in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-23-2018, 04:13 AM
  2. Formatting Cells with Date or Text Values in a Conditional Formatting Formula
    By Phil Hageman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2014, 09:36 AM
  3. Conditional formatting based on date - delete format if a date is entered in next cell
    By menstonbantam in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-23-2013, 06:21 AM
  4. [SOLVED] Conditional formatting: two different fields affect one cells formatting for a date.
    By gluktar in forum Excel General
    Replies: 2
    Last Post: 09-19-2013, 10:34 AM
  5. [SOLVED] Conditional Formatting: Highlight a cell containing a date after 1 year past that date!
    By Christopher1990 in forum Excel General
    Replies: 5
    Last Post: 08-22-2012, 05:06 PM
  6. [SOLVED] Excel 2003 date formatting error(date appears one way but is read another way)
    By cajodonn in forum Excel General
    Replies: 3
    Last Post: 07-11-2012, 10:03 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1