finding dates as close to, but >= then FY

  • 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, it is the date 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
 
The date column is formatted with date and military time. It is then sorted.
 
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

locating given dates from each year in data set 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
Calulating FY Totals 3
Dates 4
between FY date caculation 2
IF statement with two dates 2

Back
Top