UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Determining Whether A Person Falls Into A Specific Category Based On Two Dates, Office 2013    
 
   
khkeener
post Jul 11 2019, 02:01 PM
Post#1



Posts: 758
Joined: 26-February 04
From: Texas


I have spreadsheet that list individual people in my organization that may be eligible for a personal award. Column B has their Employment Start Date and Column C has their Evaluation End Period Date.

I'm trying to use the following formula in Column D to determine, and display, whether Yes, they are eligible or No, they are not eligible.

CODE
=IF (B1 <= 06/01/15) AND IF (C1 > = 12/31/15), "No", "Yes"


When I attempt to "run" this, I keep getting an error message stating that there is a problem with this formula, and to use an apostrophe to get around the problem.

Hopefully I've explained what I'm trying to do.

Any ideas?


Kevin
Go to the top of the page
 
MadPiet
post Jul 11 2019, 02:04 PM
Post#2



Posts: 3,160
Joined: 27-February 09



IF (B1 <= 06/01/15 AND C1 > = 12/31/15, "No", "Yes")

?
Go to the top of the page
 
nvogel
post Jul 11 2019, 02:13 PM
Post#3



Posts: 966
Joined: 26-January 14
From: London, UK


Try this:

=IF(B1<=DATE(2015,6,1) & C1>=DATE(2015,12,31), "No", "Yes")
This post has been edited by nvogel: Jul 11 2019, 02:14 PM
Go to the top of the page
 
khkeener
post Jul 11 2019, 02:17 PM
Post#4



Posts: 758
Joined: 26-February 04
From: Texas


nvogel, thank you very much, that worked perfectly!!


Kevin

thanks.gif
Go to the top of the page
 
Debaser
post Yesterday, 02:34 AM
Post#5



Posts: 126
Joined: 11-October 18



I don't think that formula does what you think it does, or what you want. In Excel & is a concatenation operator. You need:

=IF(AND(B1<=DATE(2015,6,1),C1>=DATE(2015,12,31)), "No", "Yes")
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    16th July 2019 - 01:23 PM