+ Reply to Thread
Results 1 to 2 of 2

if statement involving dates

  1. #1
    Registered User
    Join Date
    02-09-2020
    Location
    Massachusetts
    MS-Off Ver
    Excel 2019
    Posts
    3

    if statement involving dates

    In this spreadsheet I want to sum the prices of all the items that are purchased between February 6 and February 13 AND were purchased with a card. How would I write the forumla?
    CF1006CB-FC99-43FE-9686-AD1C3EA605EF.jpeg
    Last edited by Pepe Le Mokko; 02-10-2020 at 04:05 AM. Reason: Amended title - Refrain from adding unnecessary text

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: How to write if statement involving dates in excel?

    Hi,

    Refer to this blog

    https://www.ablebits.com/office-addi...mula-examples/
    Cheers!
    Deep Dave

+ 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] Write Sub procedure to format excel and write case/if statement to text file
    By vbronton in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-06-2018, 08:26 AM
  2. Replies: 7
    Last Post: 09-08-2016, 07:00 PM
  3. Replies: 1
    Last Post: 07-03-2013, 04:06 AM
  4. IF Statement involving a List
    By ngor3431 in forum Excel General
    Replies: 3
    Last Post: 05-16-2012, 02:36 AM
  5. [SOLVED] Excel 2007 : IF Statement involving set of Data
    By SuperHmong in forum Excel General
    Replies: 6
    Last Post: 04-25-2012, 03:35 PM
  6. [SOLVED] Tricky If statement involving dates and text - I'm stumped!!!
    By mike_vr in forum Excel General
    Replies: 2
    Last Post: 06-26-2006, 12:25 PM
  7. [SOLVED] How do I write a conditional statement in Excel to count if two c.
    By marblelife in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-16-2005, 08:06 PM

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