Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Help, I need a formula to measure if date entered in column e, is between date in column a and date in column b. please
Solved by V. U. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 23/08/2018 - 09:07
Hello
Excelchat Expert 23/08/2018 - 09:08
How are you today?
User 23/08/2018 - 09:08
HI
User 23/08/2018 - 09:09
good thank you and you?
Excelchat Expert 23/08/2018 - 09:09
I am great, thank you
Excelchat Expert 23/08/2018 - 09:10
So I need to compare Column E
Excelchat Expert 23/08/2018 - 09:10
Let's say E5 - 05/09/2018
Excelchat Expert 23/08/2018 - 09:10
and if it between A5 and C5?
Excelchat Expert 23/08/2018 - 09:11
Is that correct?
User 23/08/2018 - 09:12
to check if column E5 date entered is between dates column A and Column C
User 23/08/2018 - 09:12
yes please
User 23/08/2018 - 09:12
I need it to colour green if yes and red if no
Excelchat Expert 23/08/2018 - 09:13
Ok
Excelchat Expert 23/08/2018 - 09:13
Do you need this in excel or google spreadsheet?
User 23/08/2018 - 09:13
excel please
Excelchat Expert 23/08/2018 - 09:13
Ok
Excelchat Expert 23/08/2018 - 09:14
Please allow me few minutes
Excelchat Expert 23/08/2018 - 09:14
to do this
User 23/08/2018 - 09:14
ok, I can do this using if and false - but never with date - any help greatly appreciated
Excelchat Expert 23/08/2018 - 09:15
Since we need the colour of the particular date to change to green we need to do conditional formatting
Excelchat Expert 23/08/2018 - 09:15
If you want I can walk you through it and you can perform in your excel file
User 23/08/2018 - 09:15
yes please
Excelchat Expert 23/08/2018 - 09:16
Ok,
Excelchat Expert 23/08/2018 - 09:16
Please select the respective cells of Column E on which you want to apply this conditional formatting
Excelchat Expert 23/08/2018 - 09:16
Please tell me which is the first cell you have selected!
User 23/08/2018 - 09:17
e66
Excelchat Expert 23/08/2018 - 09:17
so you have select the cells from E66 till?
User 23/08/2018 - 09:18
e89
Excelchat Expert 23/08/2018 - 09:18
Ok
Excelchat Expert 23/08/2018 - 09:18
So while the cell are selected - Please Click on Home on the top - select Conditional Formatting - New Rule
User 23/08/2018 - 09:19
yes
Excelchat Expert 23/08/2018 - 09:19
Then select the second option - "Format only cells that contain"
User 23/08/2018 - 09:20
yes
Excelchat Expert 23/08/2018 - 09:20
1. - Select - Cell Value
Excelchat Expert 23/08/2018 - 09:20
2. Select Between
User 23/08/2018 - 09:20
yes
User 23/08/2018 - 09:21
yes
Excelchat Expert 23/08/2018 - 09:21
then
Excelchat Expert 23/08/2018 - 09:21
=$A66
Excelchat Expert 23/08/2018 - 09:21
AND IN THE LAST BOX =$B66
User 23/08/2018 - 09:21
yes
Excelchat Expert 23/08/2018 - 09:22
you have the dates in column A and B?
Excelchat Expert 23/08/2018 - 09:22
that correct?
User 23/08/2018 - 09:22
C66
Excelchat Expert 23/08/2018 - 09:22
Ok
Excelchat Expert 23/08/2018 - 09:22
then in the last Box - type =$B66
User 23/08/2018 - 09:22
yes
Excelchat Expert 23/08/2018 - 09:22
then click on format
Excelchat Expert 23/08/2018 - 09:23
select fill - choose green color
Excelchat Expert 23/08/2018 - 09:23
and click Ok
User 23/08/2018 - 09:23
yes
Excelchat Expert 23/08/2018 - 09:23
and it should work
User 23/08/2018 - 09:23
Done it - thank you Have a fab day
Excelchat Expert 23/08/2018 - 09:24
Also, if you are satisfied with my solution, please go ahead and end the session using the button on the top right hand side and requesting you to provide good feedback and review so that I can continue my services to others.
Excelchat Expert 23/08/2018 - 09:24
Thank you and have a great day!

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.