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.