Results 1 to 8 of 8

Something like countif ???

Threaded View

  1. #1
    Registered User
    Join Date
    08-04-2011
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2003
    Posts
    29

    Something like countif ???



    Hi

    Total noob at excel!

    I am managing a weed inspection program, and need a column to show reinspection dates of weed affected properties, based on initial inspection dates. That's easy. Problem is, that the reinspection date differs depending on who owns the land.

    Owner Inspection date Reinspection date
    PSC 5/08/2011
    PSC 5/08/2011
    Private 5/08/2011
    Private 5/08/2011
    PSC 5/08/2011
    Private 5/08/2011
    Crown 5/08/2011


    If the owner is PSC, the reinspection date needs to be 30 days after the inspection date
    if the owner is private, the reinspection needs to be 60 days after the inspection date
    If the owner is Crown the reinspection date needs to 1 year after the inspection date


    There are hundreds of these, so i am wondering if there is a formula to save me some time?

    Thanks in advance

    WeedMan.
    Attached Files Attached Files
    Last edited by WeedMan; 08-10-2011 at 07:52 PM.

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