+ Reply to Thread
Results 1 to 3 of 3

Ageing report in excel

Hybrid View

sam9989 Ageing report in excel 06-08-2018, 05:10 AM
Mvaldesi Re: Ageing report in excel 06-08-2018, 09:08 AM
sam9989 Re: Ageing report in excel 07-16-2018, 12:52 PM
  1. #1
    Forum Contributor Mvaldesi's Avatar
    Join Date
    01-21-2011
    Location
    Plano, TX
    MS-Off Ver
    MS365 (PC) v.2108
    Posts
    267

    Re: Ageing report in excel

    Does this work for you?

    “=NOW() – [Order Date]” calculates the current date/time minus your order date and will recalculate pretty much whenever you perform an action within the workbook.
    “=TODAY90 – [Order Date]” calculates just the current date minus your order day and only recalculates the next day.
    Attached Files Attached Files
    Last edited by Mvaldesi; 06-08-2018 at 09:26 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 07-27-2015, 01:06 PM
  2. Replies: 3
    Last Post: 07-04-2014, 09:57 PM
  3. Inventory Ageing Report
    By Josher in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-15-2013, 09:43 AM
  4. [SOLVED] ticket ageing in excel
    By allen1968 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-24-2013, 05:56 AM
  5. Debt Ageing using if in excel
    By anitajoy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-20-2013, 08:16 AM
  6. Replies: 2
    Last Post: 06-29-2011, 04:35 PM
  7. ageing report
    By chiragsk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-29-2008, 10:28 PM

Tags for this Thread

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