Macro to paste info if it is between certain dates

[ronanbaker1]

Hi Guys,

I have a macro that could have any date from 2014 to present. What I am looking for is

if the date was before 2014 then....
Or if the date was between 01/01/15 - 03/31/15 then..
Or if the date was between 04/01/15 - 06/30/15 then..
Or if the date was between 07/01/15 - 09/31/15 then..
Or if the date was between 10/01/15 - 12/31/15 then..


Any suggestions? I'm good with If formulas just not good with the dates bit.

 

[HalfAce]

Hi,
Pretty hard to get too detailed with only the example data provided. I'm sure whatever you're really doing is not quite as simple as the question being asked. (It seldom is.)
Excel just views date as numbers, so it's just a simple "If one is more than, or less than the other" kind of thing.
Say all your dates were on the active sheet, and you have 1/1/2015 in cell A1, 3/1/2015 in cell B1 and 1/18/2015 in cell D1.
You're trying to determine if the date in cell D1 is between the dates in cells A1 & B1.
A simple code example might look something like this.

If [D1] > [A1] And [D1] < [B1] Then MsgBox [D1].Value & " is between " & [A1].Value & " and " & [B1].Value

Does that help get you pointed on the direction you're looking to go?