Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 03-26-2014, 09:33 AM
akatz85 akatz85 is offline Restrict Date Range Calculations Mac OS X Restrict Date Range Calculations Office 2008 for Mac
Novice
Restrict Date Range Calculations
 
Join Date: Mar 2014
Posts: 10
akatz85 is on a distinguished road
Exclamation Restrict Date Range Calculations


any idea how to add a master dashboard or control panel that is able to tell my formulas to only look at at certain date ranges?

Admin: Split from https://www.msofficeforums.com/excel...g-4-years.html

Last edited by macropod; 03-27-2014 at 08:47 PM. Reason: Added note re thread splitting
  #2  
Old 03-26-2014, 09:39 AM
gebobs gebobs is offline Restrict Date Range Calculations Windows 7 64bit Restrict Date Range Calculations Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Which equation for example?
  #3  
Old 03-26-2014, 09:41 AM
akatz85 akatz85 is offline Restrict Date Range Calculations Mac OS X Restrict Date Range Calculations Office 2008 for Mac
Novice
Restrict Date Range Calculations
 
Join Date: Mar 2014
Posts: 10
akatz85 is on a distinguished road
Default

all of the risk and performance metrics. i want to be able to type in say march 1, 2013 - dec 31, 2013 and only see metrics based on that performance. please just let me know step-by-step so i can do it on my end too. please see attached
Attached Files
File Type: xlsx Performance SummaryFIX.xlsx (81.8 KB, 8 views)
  #4  
Old 03-27-2014, 07:39 AM
gebobs gebobs is offline Restrict Date Range Calculations Windows 7 64bit Restrict Date Range Calculations Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

See my post in your other thread.
  #5  
Old 03-27-2014, 08:46 PM
macropod's Avatar
macropod macropod is offline Restrict Date Range Calculations Windows 7 32bit Restrict Date Range Calculations Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

akatz: Please don't run the same discussion in multiple threads. Similarly, once you've finished discussion an issue in a thread, don't tack new issues onto the end of that discussion. Closing this thread.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Closed Thread



Similar Threads
Thread Thread Starter Forum Replies Last Post
Date range mysteriously adding 4 years akatz85 Excel 7 03-25-2014 12:36 PM
Restrict Date Range Calculations Date fields calculations in Word Template. kckay Word 1 10-22-2012 11:34 PM
30+ days Variable Day Date Calculations via Fields ztag Word 2 01-06-2012 11:12 AM
Restrict Date Range Calculations Date Range Prompt MikeWooZ Excel 6 12-04-2011 02:10 PM
Calculations using values from date picker controls Inkarnate Word 0 06-09-2010 07:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:33 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft