+ 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
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    23,777

    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



+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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