LinkBack URL
About LinkBacks
HI
I have a column of date data (transaction dates - not in order) and week ending dates (always a friday)
I would like to find the closest Friday to each transaction date
Any suggestions would be greatly appreciated
Thanks
Jonny
HI
I have a column of date data (transaction dates - not in order) and week ending dates (always a friday)
I would like to find the closest Friday to each transaction date
Any suggestions would be greatly appreciated
Thanks
Jonny
Are you sure this hasn't already been asked earlier on the forum?
Closest meaning what exactly? Closest in the future or closest before OR after?
Please add a few lines of sample results to your workbook - do this manually.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hi
I couldn't find anything earlier when searching
also, the file in the link will not open
I am look for the Friday before any date
Date week ending always Friday
01/10/2019 27/09/2019 Friday
02/10/2019 04/10/2019 Friday
01/10/2019 11/10/2019 Friday
02/10/2019 18/10/2019 Friday
01/10/2019 25/10/2019 Friday
02/10/2019 01/11/2019 Friday
03/10/2019 08/11/2019 Friday
04/10/2019 15/11/2019 Friday
05/10/2019 22/11/2019 Friday
06/10/2019 29/11/2019 Friday
07/10/2019 06/12/2019 Friday
07/10/2019 13/12/2019 Friday
You have marked this as solved - is it?
Using the formula from the thread to which Pepe provided a link:
=TODAY()-WEEKDAY(TODAY(),3)+IF(WEEKDAY(TODAY(),3)>4,11,4)
Change TODAY() to a cell reference (e.g. A1):
=A1-WEEKDAY(A1,3)+IF(WEEKDAY(A1,3)>4,11,4)
Last edited by AliGW; 10-25-2019 at 09:43 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks