+ Reply to Thread
Results 1 to 2 of 2

Function for days between dates and an if statement (HELP)

  1. #1
    Registered User
    Join Date
    06-08-2006
    Posts
    4

    Function for days between dates and an if statement (HELP)

    I am trying to create a function where the time between two dates is determined and if the amount of days is over 30 then their will be a red background placed in the cell. This maybe too complicated. If that will not work then the cell beside the cell that has the difference of the dates would have "overdue" written in red. Is this possible? I did figure out how to get the days between the two dates. Any help would be greatly appreciated.

    Andrew

  2. #2
    Forum Contributor
    Join Date
    06-01-2006
    Posts
    324
    Why not just use conditional format for cell value over 30?

    and then in the cell next to it. just put

    =IF(A1>30, "OVERDUE", "")
    Google is your best friend!

+ 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