+ Reply to Thread
Results 1 to 5 of 5

If condition - Change the number to Weeks

Hybrid View

  1. 10-23-2014, 08:33 AM #1
    boopathiraja
    boopathiraja is offline
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: If condition - Change the number to Weeks

    hI, tRY
    Formula: copy to clipboard 
    =IFERROR(IF(AY12-BA12<0,"",INT((AY12-BA12)/7)),"")
    ☚ Click ★ just below left if it helps, Boo?ath?
    Reply With QuoteRegister To Reply
  2. 10-23-2014, 08:56 AM #2
    arun.sj
    arun.sj is offline
    Forum Contributor
    Join Date
    06-05-2014
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    155

    Re: If condition - Change the number to Weeks

    Quote Originally Posted by boopathiraja View Post
    hI, tRY
    Formula: copy to clipboard 
    =IFERROR(IF(AY12-BA12<0,"",INT((AY12-BA12)/7)),"")
    The result came in number. how do i add "Week" to the number? if the result of the formula is "2", how do i make it to "2 Weeks"
    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] Count number of holidays depending on number of weeks
    By ANTH16 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-11-2013, 03:42 AM
  2. [SOLVED] NEW Returning 'Number' of 'Days' or 'Weeks' or 'Months' with # and text / number of employ
    By PERE in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-31-2013, 02:50 AM
  3. number of days based of number of weeks
    By trainingday in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-18-2012, 03:28 PM
  4. Excel formula to change a value every 2 weeks
    By Bobski in forum Excel General
    Replies: 2
    Last Post: 01-11-2006, 11:21 AM
  5. Automatically Change Date every 2 weeks
    By GYRO in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-04-2006, 08:15 PM

Tags for this Thread

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