+ Reply to Thread
Results 1 to 3 of 3

Need a Cell to Update Date based on a condition

  1. 10-08-2013, 09:10 AM #1
    karimel_romeo
    karimel_romeo is offline
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    103

    Question Need a Cell to Update Date based on a condition

    Hi All,

    I have a cell with a date which is linked to another cell ie A1=B1... but I need to include a rule that says that B1 should only = A1 if the date is before September 30 of the current year. If the date is later than that then B1 should change to January of the following year. An example is attached and clarifies what is needed.

    Thank you
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-08-2013, 09:16 AM #2
    Ace_XL
    Ace_XL is offline
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Need a Cell to Update Date based on a condition

    Try

    =IF(MONTH(B4)>9,DATE(YEAR(B4)+1,1,1),B4)
    Life's a spreadsheet, Excel!
    Say thanks, Click *
    Reply With QuoteRegister To Reply
  3. 10-08-2013, 09:23 AM #3
    karimel_romeo
    karimel_romeo is offline
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    103

    Re: Need a Cell to Update Date based on a condition

    Works like a charm! bingo..thank you!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Update value in cell based on date and color row
    By abdulla1 in forum Excel General
    Replies: 0
    Last Post: 06-25-2012, 02:02 PM
  2. Select worksheet based on condition & populate cell based on condition
    By beth1069 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2011, 01:27 PM
  3. get date from text & cell based on condition
    By tek9step in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-05-2011, 03:37 PM
  4. Auto insert date based on condition of another cell
    By fuston05 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-10-2010, 01:37 AM
  5. Update cell based on date range
    By deversole in forum Excel General
    Replies: 3
    Last Post: 07-06-2005, 08:58 AM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1