Forum Discussion
EXCEL - from today's date I want to find the next Friday (Every second Friday from a given date)
I'm hoping to achieve this all in one cell. My crews have every second Friday off work, so if the cell can calculate what todays date is then given a specific start date it will identify the next...
Please try this formula:
T5+Q5*7-WEEKDAY(T5+7-6)
T5: your current / ref. date: example 7thAug21
Q5: is number of week involved:
- Q5 = 1, you can find Friday in the same week (if t5 before Friday) or next week Friday.
- Q5 = 2, you can find Friday in the next week (if t5 before Friday) or next 2 weeks Friday.
Hope this is helpful for yo!
