Excel - IF Function Problem - Expert Solution

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

I would like to create the following 2 formulas within a workbook: Formula 1: Display this month's pay dates (starting from 3/24/2018 and every other Friday thereafter) in cells E4, F4 (and if applicable, cell G4). Formula 2: If any day of the month listed in cells E6 - E 16 falls after the date listed in E4, highlight red the row that lists the date. (I will duplicate this for F4 to affect cells E18-E42). I am not sure how to proceed.
Solved by E. H. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 24/03/2018 - 07:48
Hi, how could I help you ?
User 24/03/2018 - 07:50
Hi, I am unfamiliar with how to make formulas. I hope to make one and by proxy of trying to solve this, learn a little bit more about Excel. I am trying to streamline my own finances at the end of the month. I know this might take a while to solve, and I may have more questions after, and may sign up to continue working on this.
User 24/03/2018 - 07:50
or other problems in the future.
User 24/03/2018 - 07:50
I would like to create the following 2 formulas within a workbook: Formula 1: Display this month's pay dates (starting from 3/24/2018 and every other Friday thereafter) in cells E4, F4 (and if applicable, cell G4). Formula 2: If any day of the month listed in cells E6 - E 16 falls after the date listed in E4, highlight red the row that lists the date. (I will duplicate this for F4 to affect cells E18-E42).
Excelchat Expert 24/03/2018 - 07:52
Could you send to me your spreadsheet pls ?
User 24/03/2018 - 07:52
I would prefer not to because it has a bunch of numbers that I would prefer not to share.
Excelchat Expert 24/03/2018 - 07:52
if you was working on it
Excelchat Expert 24/03/2018 - 07:52
ok
Excelchat Expert 24/03/2018 - 07:55
Let me think a bit about what you need...
User 24/03/2018 - 07:55
sure
User 24/03/2018 - 07:55
I can add some values to help
User 24/03/2018 - 07:55
illustrate what I mean
Excelchat Expert 24/03/2018 - 07:55
go ahead
User 24/03/2018 - 07:59
I just need a formula that will count every other Friday's actual date in ##/##/####
User 24/03/2018 - 08:00
starting on 03/23/2018
Excelchat Expert 24/03/2018 - 08:00
ok
Excelchat Expert 24/03/2018 - 08:00
I see
User 24/03/2018 - 08:01
In my mind, I can do it. It will be like this: 03/23/2018, 04/06/2018, 04/20/2018, 05/04/2018, 05/18/2018, and so on
User 24/03/2018 - 08:02
but depending on the month, it will be a different day
User 24/03/2018 - 08:03
For instance, in April it is the 6th and 20th.
Excelchat Expert 24/03/2018 - 08:03
I know, i m close to sort it out....
Excelchat Expert 24/03/2018 - 08:07
I have finnished
Excelchat Expert 24/03/2018 - 08:07
Change value in A1
User 24/03/2018 - 08:08
Oh Interesting
User 24/03/2018 - 08:10
This is very helpful
Excelchat Expert 24/03/2018 - 08:10
Does it work how you expected ?
User 24/03/2018 - 08:12
It does work very well. I am wondering if there is a way that if the month in cell A1 is 05, that it will continue to display the current month's dates?
User 24/03/2018 - 08:13
But maybe it doesn't need to. I am trying to figure it out.
User 24/03/2018 - 08:13
This way may be better.
Excelchat Expert 24/03/2018 - 08:14
Its not easy to set it. I think this work fine for you. Glad to helped you. Have a nice day.
User 24/03/2018 - 08:16
Thank you
Excelchat Expert 24/03/2018 - 08:16
You are welcome
Excelchat Expert 24/03/2018 - 08:28
Another question (formula2 - red row...) will be answered in next session.

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.