Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    autocreate trimestral datee (2000 sr-1)

    In this sheet are peresent a block of dates in column H and I.
    Are trimestral range of dates
    Now, based the date in J1 how to autocreate the range of dates in H and I if the date in J1 change?
    For example if J1=2008

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: autocreate trimestral datee (2000 sr-1)

    Use formulas like this:

    <table border=1><td></td><td align=center>H</td><td align=center>I</td><td align=center>2</td><td align=right>=DATE(YEAR(TODAY()),1,1)</td><td align=right>=DATE(YEAR(TODAY()),4,0)</td><td align=center>3</td><td align=right>=DATE(YEAR(TODAY()),4,1)</td><td align=right>=DATE(YEAR(TODAY()),7,0)</td><td align=center>4</td><td align=right>=DATE(YEAR(TODAY()),7,1)</td><td align=right>=DATE(YEAR(TODAY()),10,0)</td><td align=center>5</td><td align=right>=DATE(YEAR(TODAY()),10,1)</td><td align=right>=DATE(YEAR(TODAY()),13,0)</td></table>
    DATE = DATO
    YEAR = ANNO
    TODAY = OGGI

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: autocreate trimestral datee (2000 sr-1)

    work perfect!
    But wath is the relation of 1,4,7,10,13 in formula...
    Not found this relation of this number in my mind <img src=/S/bash.gif border=0 alt=bash width=35 height=39>

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: autocreate trimestral datee (2000 sr-1)

    January = month 1
    April = month 4
    July = month 7
    October = month 10
    January (next year) = month 13.

  5. #5
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: autocreate trimestral datee (2000 sr-1)

    Hans(active.cell.10,10)=Sal(active.cell.0,0)
    tks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •