Question description:
This user has given permission to use the problem statement for this
blog.
I need a formula that works online to flag up dates in a column that go over 2 days e.g 27/04/2018 will flag to highlight that job needs chasing etc
Solved by A. U. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
02/05/2018 - 10:40
Hi
Excelchat Expert
02/05/2018 - 10:40
Welcome to Got it pro
Excelchat Expert
02/05/2018 - 10:41
Are you there?
User
02/05/2018 - 10:41
Hi
Excelchat Expert
02/05/2018 - 10:41
Do you have any excel sheet?
User
02/05/2018 - 10:41
Yes
User
02/05/2018 - 10:41
Have added a link
Excelchat Expert
02/05/2018 - 10:41
Can you send it to me
Excelchat Expert
02/05/2018 - 10:41
Oh ok. Just a minute
Excelchat Expert
02/05/2018 - 10:42
Its not yet loaded.
User
02/05/2018 - 10:42
Can you click on the link?
Excelchat Expert
02/05/2018 - 10:42
Its asking password
Excelchat Expert
02/05/2018 - 10:42
Yes... But need password to login this link
Excelchat Expert
02/05/2018 - 10:43
Ok let me check
Excelchat Expert
02/05/2018 - 10:44
?
User
02/05/2018 - 10:44
Just seeing what else i can do
Excelchat Expert
02/05/2018 - 10:44
Just copy paste sample data here
Excelchat Expert
02/05/2018 - 10:45
or you can tell me your scenario let me create sample data
User
02/05/2018 - 10:45
https://tesco-my.sharepoint.com/:x:/r/personal/adam_x_james_tesco_com/_layouts/15/WopiFrame2.aspx?sourcedoc=%7BCEA2B9B9-0639-49FD-A1C6-42090830CD6B%7D&file=Asset%20Condition%20Report.xlsx&action=edit&d=wcea2b9b9063949fda1c642090830cd6b
User
02/05/2018 - 10:45
It wont let me paste
User
02/05/2018 - 10:46
hang on
Excelchat Expert
02/05/2018 - 10:46
ok..its not working.
Excelchat Expert
02/05/2018 - 10:47
you would like to highlight the dates column for next two days correct
User
02/05/2018 - 10:48
I have a list of jobs with a column of dates as to when each came in. I want to flag any jobs that go over their date by 2 days so as to be highlighted
Excelchat Expert
02/05/2018 - 10:48
ok. let me give you example
Excelchat Expert
02/05/2018 - 10:50
can you give me some example
User
02/05/2018 - 10:50
hang on
Excelchat Expert
02/05/2018 - 10:50
sure
User
02/05/2018 - 10:52
Example on the sheet
Excelchat Expert
02/05/2018 - 10:53
yes...
Excelchat Expert
02/05/2018 - 10:53
which one you would like to hightlight
Excelchat Expert
02/05/2018 - 10:53
within two days items correct
User
02/05/2018 - 10:53
Any jobs that go over 2 days of their date(in column). So in this case all would be flagged apart from the last one
Excelchat Expert
02/05/2018 - 10:54
ok give me few minutes
User
02/05/2018 - 10:54
No worries
Excelchat Expert
02/05/2018 - 10:55
sorry...
Excelchat Expert
02/05/2018 - 10:56
For example today is 2nd May
Excelchat Expert
02/05/2018 - 10:56
do you want to highlight the date till 4th May?
Excelchat Expert
02/05/2018 - 10:56
???
Excelchat Expert
02/05/2018 - 10:56
Any jobs that go over 2 days of their date(in column).
Excelchat Expert
02/05/2018 - 10:57
???
Excelchat Expert
02/05/2018 - 10:57
???
Excelchat Expert
02/05/2018 - 10:57
Are you there?
User
02/05/2018 - 10:58
Yes you are right
User
02/05/2018 - 10:58
all dates should be highlighted apart from the 01/05/2018 as that would highlight tomorrow
Excelchat Expert
02/05/2018 - 10:58
oh ok.
Excelchat Expert
02/05/2018 - 11:01
Can you check this
[Uploaded an Excel file]
Excelchat Expert
02/05/2018 - 11:01
Can you check this file and confirm
Excelchat Expert
02/05/2018 - 11:03
Please ignore the previous one check this file
[Uploaded an Excel file]
Excelchat Expert
02/05/2018 - 11:04
Is it fine?
Excelchat Expert
02/05/2018 - 11:06
???
Excelchat Expert
02/05/2018 - 11:06
Are you there?
Excelchat Expert
02/05/2018 - 11:17
Request you to connect with us again for any other queries. Thanks
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.