Forum Discussion
Solved
Trying to find nearest specific date from another date
I'm trying to create a formula where by I can find the nearest monday OR wednesday to a specific date i.e. 12/8/23 - any help?
With a date in A2:
=A2+IF(WEEKDAY(A2,13)<=3,1,6)-WEEKDAY(A2,13)
or
=LET(d, WEEKDAY(A2,13), A2+IF(d<=3,1,6)-d)
With a date in A2:
=A2+IF(WEEKDAY(A2,13)<=3,1,6)-WEEKDAY(A2,13)
or
=LET(d, WEEKDAY(A2,13), A2+IF(d<=3,1,6)-d)
Hi Hans,
This has worked perfectly. Thanks ever so much!
This has worked perfectly. Thanks ever so much!