RE: locating given dates from each year in data set

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Papa Jonah (PapaJonah_at_discussions.microsoft.com)
Date: 10/25/04 

Date: Mon, 25 Oct 2004 15:33:06 -0700

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?

"Papa Jonah" wrote:

> 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
>
>

Relevant Pages

  • RE: Locating a value anywhere in a row and copying that row to new
    ... the data set has no enitirely blank rows or columns in the data set. ... CurrentRegion is the range bounded by any combination of blank rows and blank ... Assuming your data starts in Cell A1, you could use the following code to ... >> End Sub ...
    (microsoft.public.excel.programming)
  • Re: Like .CommandBars("Cell") in Page Break Preview
    ... TIA = Thanks In Advance. ... > Jim Cone ... > San Francisco, USA ... > able to present some right-click options, whether the cell is ...
    (microsoft.public.excel.programming)
  • Re: Adding Row Number to Column
    ... With the data set out in the same way as in my first reply: ... Bernard V Liengme ... Cell Reference to use within a SUM/AVERAGE calculation? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: I need a february 29th row, but only if the day of year actually exists
    ... and the plotted chart would respond accordingly. ... If the day does not exist, the cell remains blank, and the plot figures ... Can the data set a plot is derived from be called out in a cell such ... So I could mark the sheet at the 28th ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Conditional actions
    ... input a data set of variable length, and then have a VBA GUI pop up and the ... data into a cell, and an equation in another cell will then convert that to ... > In a macro, there is no need for the INDIRECT function. ...
    (microsoft.public.excel.programming)