+ Reply to Thread
Results 1 to 3 of 3

help needed with if then statement containing date between 21st and 30th

  1. #1
    Forum Contributor
    Join Date
    12-18-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 365
    Posts
    108

    help needed with if then statement containing date between 21st and 30th

    Hello team,

    I need some help wiht an if then statement.
    I have tried something but it's not showing any results when I run my macro, so something must be amiss....

    This is what i have come up with so far:
    Please Login or Register  to view this content.

    Note:
    - AA = today's date
    - G = country name

  2. #2
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: help needed with if then statement containing date between 21st and 30th

    Please Login or Register  to view this content.
    if AA=today then replace day(cells(i,"AA").value) with day(date)
    Last edited by bsalv; 02-20-2014 at 06:52 AM.
    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

  3. #3
    Forum Contributor
    Join Date
    12-18-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 365
    Posts
    108

    Re: help needed with if then statement containing date between 21st and 30th

    Thank you, works perfect!

+ 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. Formula for Friday 14 days from start date, but closest to 15th or 30th
    By SiRCYRO in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-23-2013, 08:23 PM
  2. Replies: 1
    Last Post: 09-07-2012, 12:00 PM
  3. Excel Date criteria in SUMIF statement help needed
    By imcilwee in forum Excel General
    Replies: 2
    Last Post: 04-04-2012, 05:05 AM
  4. MSGraph Showing All Month-Ends as 30th.
    By Alan Z. Scharf in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-18-2006, 11:40 AM
  5. exel 2000 st in 21st to move up
    By vikesanimal in forum Excel General
    Replies: 2
    Last Post: 04-01-2005, 07: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