+ Reply to Thread
Results 1 to 2 of 2

Needed formula

  1. #1
    Registered User
    Join Date
    12-01-2019
    Location
    Mumbai,india
    MS-Off Ver
    MS office 365
    Posts
    2

    Needed formula

    Dear Team,

    in my sheet there are three column 1 ) Date 2 ) Status 3)New Status .

    For All Paid invoices : If the date is from Dec then new status should be Paid in Dec if not then Prior to

    I had attached my original file as well as resolution file
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Needed formula

    Please one sample file, with some manually calculated answers... I have no idea where columns D & E came from and how they form part of the solution.

    Also, your thread title is awful. It should resemble the phrase that you would use in a Google search. Would "Needed formula" do that?? It would produce no useful hits at all. Since you're new I will change it for you - this time - once I understand what you want!!
    Last edited by Glenn Kennedy; 12-03-2019 at 12:21 PM.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ 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. [SOLVED] Improved Formula / i've run out room to extend the current formula / (avdanced code needed
    By pmw19800 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-29-2018, 06:19 AM
  2. date formula help needed with blank cell and monthly assumtions formula needed
    By Michael.Howarth in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-31-2018, 07:47 AM
  3. Replies: 3
    Last Post: 04-06-2016, 12:19 PM
  4. Replies: 1
    Last Post: 01-11-2016, 02:31 PM
  5. Replies: 7
    Last Post: 02-03-2013, 06:25 PM
  6. [SOLVED] index formula needed--how to get a formula to skip columns
    By rsmidtisu in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-02-2012, 11:22 AM
  7. Replies: 3
    Last Post: 09-07-2012, 12:07 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1