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.
