+ Reply to Thread
Results 1 to 4 of 4

Date Projection on Excel

  1. 04-02-2007, 11:24 AM #1
    borak2k7 is offline
    Registered User
    Join Date
    03-28-2007
    Location
    Leicester, UK
    Posts
    11

    Date Projection on Excel

    Hi, I need to create a formula that takes an entered date and projects 4 weeks from that date. For example if I was to enter the start date of a project, I would like a formula to automatically fill a cell with a date of 4 weeks from that day. It is so when we put a date ordered it automatically gives us a completion deadline.

    Any help guys?
    Reply With QuoteRegister To Reply
  2. 04-02-2007, 11:37 AM #2
    BigBas is offline
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    Couldn't you just use a formula like this:

    =A1+28

    assuming your start date is in A1
    Reply With QuoteRegister To Reply
  3. 04-05-2007, 09:14 AM #3
    borak2k7 is offline
    Registered User
    Join Date
    03-28-2007
    Location
    Leicester, UK
    Posts
    11

    Red face

    Lol it worked a charm! Didn't think it would be that easy!

    Thanks for that!!
    Reply With QuoteRegister To Reply
  4. 04-05-2007, 10:56 AM #4
    BigBas is offline
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    Glad I could help.
    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)

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