+ Reply to Thread
Results 1 to 3 of 3

How could I put these two formulas together?

Hybrid View

  1. #1
    Registered User
    Join Date
    09-07-2016
    Location
    Chile
    MS-Off Ver
    office 360
    Posts
    4

    How could I put these two formulas together?

    Hello:

    I have this table:

    -------A-----------B----- COUNTIF=COUNTIF(B1:B5;">=01-12-15") (formula 2)
    1 01-12-15 =A1+30 (31-12-2015) (formula 1)
    2 01-12-15
    3 05-12-12
    5 08-12-15

    I add a new column and add number to the dates with formule 1.

    Next, I count the dates with COUNTIF=COUNTIF(B1:B5;">=01-12-15")

    How could I put these two formulas together without adding column B?

    Thanks!!
    Last edited by Veronsito; 11-27-2016 at 12:57 PM.

  2. #2
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

    Re: How could I put these two formulas together?

    in c1 and down use
    =TEXT(B1+30,"dd-mm-yyyy") &"-" & COUNTIF($B$1:$B$4,">=01-12-2015")
    Kamboj
    _________________________________________________________________________________
    Mark the thread as SOLVED if my answer satisfy you.

  3. #3
    Registered User
    Join Date
    09-07-2016
    Location
    Chile
    MS-Off Ver
    office 360
    Posts
    4

    Re: How could I put these two formulas together?

    My mistake , now the answer would be the same?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Generating formulas into specific cells, based on various formulas
    By S_O_A_L in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2016, 08:45 PM
  2. Replies: 9
    Last Post: 12-04-2015, 05:19 PM
  3. Poll on - Lots of simple formulas vs fewer but more complex formulas
    By gassiusmax in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-20-2014, 08:51 PM
  4. Using Cell references in file paths for formulas to create dynamic formulas
    By MichaelStokesJr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-04-2013, 11:49 AM
  5. Replies: 5
    Last Post: 09-25-2013, 02:51 PM
  6. Ctrl+Shift+Enter (CSE) array formulas in VBA using differing formulas
    By officeguy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2012, 04:31 PM
  7. Replies: 5
    Last Post: 05-05-2008, 02:22 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1