Is this possible (IF with dates)

Solrax - Jun 7, 2016 at 09:25 AM
 Blocked Profile - Jun 8, 2016 at 06:56 PM

I need some help with what to input into Excel for a function I'd like to see.

What I'm looking at doing is:

Lookup all dates on "sheet 1", if date is between 5 months and 1 day and 6 months then display "name listed on sheet 1 next to date"

The next one would be same as above but between 4 months 1day and 5 months.

There is more but with those two I should figure out the rest of the coding. It starts in months and goes down to weeks and days.

Is there a way to do this? Thanks in advance for any help.

1 response

Blocked Profile
Jun 7, 2016 at 04:33 PM
OK. Well this is going to be hard, because how many days are in a month?

5 months from January to May on a leap year will generate one more day then the previous day. So, how do you qualify those years?
You are right! I didn't think of that. Would it be easier to do by days? For example the "block" were I input for 6 months, we can say if it's between 150 and 180 days display "name" of event here or else display nothing. Then for 5 months we can do if between 120 days and 180 days...... So on and so forth. I could figure out for the most part how to adjust the dates. Just can't think of how to have it search for dates in all of sheet 1, then calculate dates so EVENT DATE - TODAYS DATE = XXX DAYS, therefore input "NAME" here.
Blocked Profile
Jun 8, 2016 at 06:56 PM
Yup! Let us know if you need help with functions!