Re: Need help with date range

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi

I read it the wrong way round
Change to
=YEAR(A19)+(MONTH(A19)>6)
Leave the format as General

Regards

Roger Govier


RJohnsonHC wrote:
DOH! You're quite right, Roger. I meant to say 6/30/2006! I tired using your formula, but it actually gives me the year prior to what it should be, i.e.,

6/30/2006 returns "2005) with formula "=YEAR(J2)-(MONTH(J2)<7)"

My dates are in column J...

Many, many thanks!

-RJ

"Roger Govier" wrote:


Hi

From the dates given, it looks like a 13 month year!!
I suspect you either meant 7/1/2005 and 6/30/2006 or 8/1/2005 and 7/31/2006

Taking the latter case, and assuming your dates are in column A, in column B
=YEAR(A2)-(MONTH(A2)<8)
Change the 8 to a 7 if the Year begins in July rather than August.
If you only want to show a 2 digit year, format the cells as yy

Regards

Roger Govier


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! 

.

Relevant Pages

  • Amber might wearily fund our tone
    ... Somebody adjust once, chew occasionally, then enhance ... but the format except for the regiment. ... It will contribute round if Najem's birth isn't fantastic. ...
    (sci.crypt)
  • Re: Total and Round problem?
    ... The problem is that the values shown when you set the format of a control, ... To resolve this you have to round the primary values in the underlying query ... Dim varTemp As Variant ...
    (microsoft.public.access.reports)
  • Re: Another Garbage WC scheduling / rules
    ... let's come up with a format which finds the best eight sides really quickly then lets them play amongst themselves. ... I don't understand what is the lottery of the knockout stages. ... Top two in each group go to round 2. ...
    (rec.sport.cricket)
  • Re: (R) Brasileiro Serie C, Round 1
    ... It is the apparent format setback that puzzles me. ... its final round, and the octogonal was very recent as well). ... with a 8-team final league and a national TV deal (for ... The first club to wake up and seize the opportunity will be golden ...
    (rec.sport.soccer)
  • Re: Team tournament at Pinball Expo
    ... We were thinking that we'd like to do a team pingolf format. ... If the score is achieved on ball 1 then the player ... achieved in a 3 ball game then the player would receive a 4. ... We were thinking that we would play a round of "golf" then ...
    (rec.games.pinball)