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...
If in A1 is the start date, the formula could be
=A1+(INT((TODAY()-A1)/14)+1)*14For example, if in A1 is Jan 10, 2020 and today is Apr 21, formula returns May 01, 2020
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!