Results 1 to 9 of 9

Insert a future date based on a number in another cell

Threaded View

  1. #1
    Registered User
    Join Date
    05-10-2010
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    9

    Question Insert a future date based on a number in another cell

    Hi

    i'm trying to use an IF statement to insert a working day date later than today's date based on a number in another cell. For example if C2 has a number 5 in it then a date should automatically be entered, this being 5 working days from now.

    here is what i have at the moment

    =IF(C1:C5000="2",WORKDAY(TODAY(),2,""))*IF(C1:C5000="1",WORKDAY(TODAY(),1,""))*IF(C1:C5000="5",WORKDAY(TODAY(),,""))*IF(C1:C5000="3",WORKDAY(TODAY(),3,""))

    but is does not work as i get this 00/01/1900 in each cell.

    I'm new to this and i'm learning as i go along but this has me stumped!!
    Last edited by LongShanks; 05-10-2010 at 10:55 AM.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1