+ Reply to Thread
Results 1 to 4 of 4

Ageing Calculations

  1. #1
    Forum Contributor
    Join Date
    10-24-2006
    Location
    INDIA
    MS-Off Ver
    office 2010
    Posts
    190

    Ageing Calculations

    Dear Team,

    I am calculating the ageing for my action items, this formulae (=TODAY()-E4) will give the output for how many days are left over to complete my tasks (Cell E4 is my Target date)

    Now the problem is once the task is completed ageing calculations should stop and show the difference between target gate and closing date can anyone please suggest some formulae

    Regards,
    Sagar

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Ageing Calculations

    Maybe =IF(today()<=E4,today()-E4,F4-E4) if F4 contains closing date

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Ageing Calculations

    The TODAY Function is volatile, so it will change daily
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Ageing Calculations

    Quote Originally Posted by royUK View Post
    The TODAY Function is volatile, so it will change daily
    Which is why I get older each day !

+ 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