+ Reply to Thread
Results 1 to 2 of 2

Showing results via date

  1. #1
    Registered User
    Join Date
    11-19-2013
    Location
    Brisbane, Australia
    MS-Off Ver
    Professional Plus 2010
    Posts
    1

    Showing results via date

    Hey Guys,

    First time posting on here, but I'm writing up a budget, and I just wanted to know if there is a function where I can have something like this:

    As at =TODAY

    Outstanding bills: (amount as per date)
    More Bills: (amount as per date)
    Student Debt: (amount as per date)

    and have it move down the budget on the other page, following the date in a range of dates.

    So say if it was today's date, 20/11/2013(australian, sorry) then it would look up budget from 27/11/2013

    and after that date, say the 28/11/2013, it would look up the one from 11/12/2013

    Is that possible without a massive page of IF and Then functions?

  2. #2
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Showing results via date

    so you want values( budget information ) from 2 weeks ahead, or 1 week ahead, or am I missing something ?
    to change days is easy add (or subtract) # of days to (from) a date value, and that's the info you get, just not sure what we are looking for here...
    A sample WB with expected output and reason WHY it is expected would definitely help here
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

+ 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. Results showing 0.00 and (0.00)
    By hvaleagues in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-19-2011, 02:43 PM
  2. Results aren't showing
    By Mooseknuckle in forum Excel General
    Replies: 2
    Last Post: 03-03-2011, 06:16 PM
  3. Filter not showing all results
    By Newton1234 in forum Excel General
    Replies: 2
    Last Post: 02-19-2009, 08:01 AM
  4. search and showing results
    By gbWildy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-26-2007, 06:18 PM
  5. Formulas not showing results
    By sonar in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 09-06-2005, 09:05 PM

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