Re: Need help with date range

You could probably use a formula that returns the year.

It could be as simple as
=year(a2)

But if your fiscal year isn't from Jan to Dec, you may want to post the dates.

In fact, if you post your rules, you could even get a formula for fiscal quarter
(just in case you ever need it).

RJohnson701CTS wrote:
>
> Hi, all. I'm trying to do something that's probably pretty simple, but I
> don't know how to do it. I've got a column of dates in my SS. What I want
> to do is if a date in the column falls between a certain date range, then in
> the column next to the date it gives a two-digit year. For example,
> 12/31/2005 falls between 7/1/2005 and 7/31/2006, so in the column next to
> "12/31/2005" it would say "06" or "2006" or something like that. I want to
> be able to do this with several date ranges. (I'm basically trying to
> translate dates in fiscal years.) Can anyone give me some tips? Thanks in
> advcance!

--

Dave Peterson
.

Relevant Pages