+ Reply to Thread
Results 1 to 3 of 3

return dates based on subscription

  1. #1
    Registered User
    Join Date
    04-28-2019
    Location
    france
    MS-Off Ver
    14.1.3 (2011)
    Posts
    3

    return dates based on subscription

    hello,
    I'm no excel expert and am looking for what I believe to be a simple function for someone who knows excel.

    I'm currently trying to find a way to return the date of subscribers based on the date the subscription fee was collected.

    In the attached excel file, I have two sheets:

    _one with the general accounting data with expenses and entries (which include subscription fees as well as other expenses and entries),
    _one with the subscription data that condenses the subscriber data and lets me know if they subscribed and when.

    At the moment the function to return the date based on whether or not they have paid their subscription returns random results.
    this is the function that doesn't seem to do the job:
    =IF(E2>0,'recette-dépense 2019'!A:A)

    I think I maybe need some kind of nested if function that does the following:
    _matches the name of the person in "subscription" sheet with the name in "recette-dépense 2019" sheet
    _checks that his name is associated with an 'adhérent' catégorie in "recette-dépense 2019" sheet (column 2 in "recette-dépense 2019")
    _and if all that if true, then return the date that corresponds to that row

    I was wondering if someone could help me find a solution to this request.

    with many thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,225

    Re: return dates based on subscription

    try this

    Please Login or Register  to view this content.
    it I anray formula, so it has to be entered with Ctrl-Shift-Enter

  3. #3
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    10,965

    Re: return dates based on subscription

    @t.dot
    Hi and welcome
    to ensure that you get faster answers, it is best to create a new thread when you have a new question ( with eventual links to any relevant posts - as long as you don't have 10 posts, ask a mod to add the link if needed)
    I created a new thread for you https://www.excelforum.com/excel-for...ml#post5110893
    Good luck with your query
    Last edited by Pepe Le Mokko; 04-28-2019 at 11:58 AM.

+ 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] Return a value based on a range of dates
    By LucyJW in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-18-2018, 10:06 AM
  2. [SOLVED] Help using IF to return different values based on dates
    By 61dtl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-16-2017, 11:16 AM
  3. Sum to return figures based on dates
    By gandyling in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-26-2015, 05:05 AM
  4. [SOLVED] Return dates based on week selected
    By john dalton in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-13-2013, 08:38 AM
  5. Macros - Return a value based on two dates
    By jtd84 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-26-2012, 12:02 AM
  6. return rows based on MIN & MAX dates
    By robotlust in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-30-2008, 09:31 AM
  7. [SOLVED] return based on range of dates
    By Matt in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-15-2006, 04:40 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