Results 1 to 15 of 15

Formula to show a date range based on the amount shown in another cell

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-15-2005
    MS-Off Ver
    Office 2007
    Posts
    346

    Formula to show a date range based on the amount shown in another cell

    Attached is a excel file that has a working formula for tracking cashier variances. I edited out names etc.

    I added a new cell called Track Back on the employee search sheet.

    What I want to do is only show variances for the amount of days back selected in the Track Back cell.

    For example if I select the last 30 days, only the last 30 days would show up below in the sheet.

    I am not sure if this is even possible based on the forumla that is already on the sheet. I couldn't figure out a way of doing it. But there are a lot of people on here much better with excel than me

    Thanks for any help with this, I really appreciate it.

    Nick
    Attached Files Attached Files
    Last edited by avidcat; 09-11-2009 at 08:51 AM.

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