+ Reply to Thread
Results 1 to 4 of 4

how to program the Exipred Date column to show the date 6 months

  1. #1
    Registered User
    Join Date
    11-23-2007
    Posts
    3

    how to program the Exipred Date column to show the date 6 months

    Hi,

    I have been asked to create a spreadsheet with three columns Status - Qualified Date - Expired Date.

    The Status column shows a green box with "Status" written in it

    The Qualified date column is filled with dates.

    I need to know how to program the Exipred Date column to show the date 6 onths later from the Qualified date Column.

    and when a column reaches the date 6 month's on, for the status box to turn red with "expired written in it.

    Can this be done and if so, could someone show me please.

    Thanks

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    It's not always obvious which date is "6 months on". For 31st August 2007 what date do you expect?

    =EDATE(B2,6)

    will give you 29th February 2008

    EDATE function requires Analysis ToolPak to be installed

    Assuming your status is in A2, qualified date in B2 and expired date in C2 then A2 could contain the formula

    =IF(C2>=TODAY(),"expired","status")

    Use conditional formatting to change the colour to red when "cell value is" ="expired"

  3. #3
    Registered User
    Join Date
    11-23-2007
    Posts
    3
    Thanks,

    I have everything working except the =IF(C2>=TODAY(),"expired","status").. It just shows the function in the cell not the expired or status.

    Was there something missed?

  4. #4
    Registered User
    Join Date
    11-23-2007
    Posts
    3
    Thanks,

    I have everything working except the =IF(C2>=TODAY(),"expired","status").. It just shows the function in the cell not the expired or status.

    Was there something missed?

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1