locating given dates from each year in data set

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a sheet with a bunch of dates in Column A:
For charting purposes, that I am trying to automate, I need Excel to locate
the earliest date in the fiscal year cycle. In our case, the date is as
close to >=10/1 of any given year. I also need to be able to do this for
each
FY in the data set.

Any help would be greatly appreciated.
TIA
 
okay, how about if I make this easier and just ask how to write a code that
will return the year of a cell that is formatted with date and military time?
 
Can you give an example of the EXACT contents of a cell? Does Excel recognize
your entry as a date and time, or (because of the time entered without a
colon) does it think it's text?
 
This is as formatted by Excel
4/8/97 13:00
Column A is filled with similar date/times that span several years. These
cells are used to calculate elapsed time as well as charting of events.
When we want to modify charts to look at a given year or given set of years,
we need to manually alter the series.
My immediate objective is to use excel to automatically identify statistical
significance by evaluating blocks of data where each block adds a year until
significance is found.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

finding dates as close to, but >= then FY 2
End of Quarter Based on Fiscal Year 2
Access 2 Digit year in Access Text Box 3
Macro to break one row of data into multiple rows, with calcuation 1
Code Optimization 0
Excel Message box called if 1 of 3 options is entered. 4
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
My own fiscal year 3

Back
Top