You are here: HomeExcelTutorials

# Finding Nearest and Furthest Date

## Finding Nearest and Furthest Date

Price: FREE

My data table is like so. My date format is YY/M
Today 7-Aug
Stock Date
SPY 7-Oct
SPY 7-Dec
SPY 10-Dec
OIH 9-Jan
Trying to create this table. Basically I am trying to find the date in the data table that is the closest and furthest away from today's date.
DateMax DateMin
SPY 10-Dec 7-Oct

Visit publisher's web-site: Finding Nearest and Furthest Date

Category and Tags: ExcelTutorials : : Functions

## Related Tutorials

### Finding the nearest day

Free: Yes
Tags: Excel ›

Sometimes I need to calculate different coefficients and ratios for the specified period (only weekdays).
To do this, I usually enter manually starting and ending date in the cells. But due to the fact that I have only weekdays I periodically get an error #N/A, because there is no such date in my sample (for example it was a day off and I skipped it).
I wonder, if there is a way in Excel to give a hint what is the nearest day to that I entered manually so I don't have to scroll down my sample to find it visually.
Please, take a look at the attached file.

### Formula for Finding the Nearest Number

Free: Yes
Tags: Excel ›

creating a formula that finds the nearest number.
Example:
A1: 100
B1: 200
C1: 175
D1: 200
Whichever number C1 is nearest too the answer would be placed in D1.
So D1 would equal 200.

### RANK Function

Free: Yes
Tags: Excel ›

I'm sure there is an easy way of doing this .
I have a list of data values that I want to rank in terms of the
nearest/furthest away from zero. Some of the values are positive and some are negative.
How do I use RANK such that No 1 is the value (positive or negative) that is nearest to zero, No 2 is next nearest, etc?

### Using furthest down Cell for math statements

Free: Yes
Tags: Excel ›

I have printer toner usage sheet that has dates in a column I want it to reference the furthest one down to complete its job. I've attached an example excel file of what I've to to make it work but its dirty and doesn't work properly if the value changes to 100%, if I change the cartridge. For the most part what I have works but its terrible and difficult to alter.
What I'm trying to get it to do is find the average Page Per Day printer from the top value OR if column C has a cell with 100%. Additionally, I need it to references the furthest cell down that isn't 0 or nothing to find out which date to use to figure replace by date and the toner empty date. I'm hoping for a more elegant solution that I'm currently using that is accurate even if the toner level goes up.

### Highlight date nearest to TODAY()

Free: Yes
Tags: Excel ›

I have dates in a column in this format :
I'm trying to set the conditional formatting so that the nearest date to today is in bold.

## Related Applications & Scripts

### Geographic Distance and Azimuth Calculator

Free: Yes
Tags: PHP › Excel Geolocation

GeoCalc is a PHP and (MySQL) API that is useful in performing distance calculations between two distinct points on the earth's surface. Used in most GIS (Geographic Information Systems), these are standard algorithms with various levels of accuracy. Simple example of uses for this software would be to find the nearest store location to you, or finding the straight-line distance between two points on a map.

### Analog Clock with Frame

Free: No
Tags: Flash › Excel Clocks

This clock is taking the time off your local computer and displaying it on the web page through Flash. This is not perfect as I don't know if your clock is correct. There are other ways of finding out the time but they are much more complicated and not necessarily more accurate. So I have gone for a very simple method of finding out the time. It works and is not too difficult to create.

### Date icon component

Free: No

This is a simple component that can be added to an application showing the current date (or a selected date).
It is easily skinnable using flex css styles.

### Filter Large Select Lists

Free: Yes
Tags: JavaScript › Excel Forms

If you have a very large HTML SELECT list, finding the correct item can be like looking for a needle in a haystack. For example, if you have a list of a couple hundred names, finding a single one can be difficult. This article provides a JavaScript technique for filtering the items in a select list so that only the matching items are shown, making it much easier to locate the desired item.

### Date Picker as3

Free: No
Tags: Flash › Excel Date and Time