Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Montreal, Quebec
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculating dates

    Hi there,

    A1 = Nov 12, 2011
    I want B1 to show the date of the next January 1 that is at least one year from A1 i.e. result would be Jan 1, 2013 in this case.
    Help please.
    Johanne Champagne
    Montreal (Quebec) CANADA

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi Johanne

    If I understand the question correctly, then unless the date in cell A1 happens to be Jan 1st, then the next January 1st that is at least one year away will always be:
    =DATE(YEAR(A1)+2,1,1)

    ..so you could add a test for If a1 is already a Jan 1st etc etc.
    zeddy

Posting Permissions

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