How would a formula look if I wanted to find the Week ending date of a certain date. The last day of the week being Saturday. Please see attached example. I was thinking I can always do a Vlookup but I still would need the formula. can anyone help me with this?
Thank you,
Trish
Book1.xlsx
Last edited by trosasco; 02-06-2014 at 10:33 AM.
try:
Formula:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Sure, first make a little table to convert Month to a Month number.
I put Jan in K2, 1 in L2 down to Dec in K13 and 12 in K13.
In E2:
=IF(7-WEEKDAY(VLOOKUP(B2,$K$2:$L$13,2,0)&"/"&C2&"/"&D2)<>0,7-WEEKDAY(VLOOKUP(B2,$K$2:$L$13,2,0)&"/"&C2&"/"&D2)+(VLOOKUP(B2,$K$2:$L$13,2,0)&"/"&C2&"/"&D2))
and copy down
Edit: And today I learned about a function called Datevalue()
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
check the attached file
Check the attached file
Thank you all... That worked great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks