Jul 03 2021 10:51 PM
Hello! I am trying to figure out how to create a function or use a tool in excel that allows me to create a result based on a date. I am creating eligibility and ineligibility lists for a job, and it's based on a set date. to be eligible it has to be before May 7, 2019. Ineligible is after May 7, 2019. I want the column that will says eligible or ineligible for each person's name to be set in the row after the date. Any idea how to do this? It doesn't seem to work when I try with "a date occurring rule for formatting cells".
Jul 03 2021 11:08 PM
@Katie17626 Use a formula in stead of conditional formatting. See picture below.
Jul 11 2021 08:36 AM
@Riny_van_Eekelen thank you for the help with this. I’m still confused with how you did the part with the B1 name range cut off. Could you please explain further? I also don’t want to show the formula work on my spreadsheet if possible :)
Jul 11 2021 09:07 AM - edited Jul 11 2021 09:08 AM
@Katie17626 The formula I provided is a simple IF function. I named one cell "cutoff" and used that name as a reference. I could have used $B$1 also. If a date, in your case, perhaps in column A, is less than or equal to a cutoff date than "Eligible", otherwise "Ineligible".
Not sure what you mean when you say that you "don't want to show the formula work". So you want cells to display "Eligible" or "Ineligible" but not have a formula in these cells. Then you are talking VBA. Not my area of expertise. Sorry!
Jul 12 2021 01:30 PM