Excel Date Question I have a list of dates, and I am needing to know the excel f
ID: 3560757 • Letter: E
Question
Excel Date Question
I have a list of dates, and I am needing to know the excel formula to find the following Friday for each date in my list. I have had some success with th is but ran into problems when it came to dates that fell on the weekend (Sat and Sun). So I had to use two different formulas..which took way too much time. I am looking for one formula to use for any date that will give me the following Friday date.
Example:
08/04/2014 --> need a fomrula to bring back the following Friday...which is 08/08/2014
08/16/2014 --> Saturday (falls on weekend) need a formula (that will work the same on a week day) to give me the following Friday...which is 8/22/2014
Explanation / Answer
)One question is what you want to return if the given date IS a Friday6
To always return the NEXT Friday, even if the date in A1 is a Friday:;'
=A1+8-WEEKDAY(A1+2)
To return the NEXT Friday, UNLESS the date in A1 is a Friday, in which case return the date in A1:
=A1+7-WEEKDAY(A1+1)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.