hello
will it be possible to find a specific date based on the day of the week and the day of the month with a formula
for example find the date of the fifth Thursday in February ?
Thank you in advance
hello
will it be possible to find a specific date based on the day of the week and the day of the month with a formula
for example find the date of the fifth Thursday in February ?
Thank you in advance
A bad example... as there is a 5th Thursday in February ONLY when 1st is a Thursday AND it's a leap year!!
With date in A2, to get the 4th Thursday in Feb 2022
=WORKDAY.INTL($A2-1,4,"1110111")
where the bit in red defines the n in nth occurrence and the blue 0 defines the day of the week (in Mon-Sun order)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks for the answer
100% solved
You're welcome & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks