Return Week Ending Date (Friday)
I need to return the week ending date (Friday) for any given date entered in the first column (A). My billing cycle week ends on a Friday, and the new billing week technically starts the next day (Saturday).
I have used the following formula, but it calculates the end of the week as Saturday. So, when I enter a Saturday (the start of a new billing cycle), it returns the date from the preceding Friday (the day before). All other days of the week return the proper Friday date (Sun -- Friday) How can I modify this formula so that Saturday is the start of the week and Friday is the end of the week?
A1+6-WEEKDAY(A1,1))
Perhaps:
=A1+7-WEEKDAY(A1+2,2)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Hi
If i understoond well, your point, then try this:
=A1+6-WEEKDAY(A1;2)
Hope to helps you
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Trying to mark Thread as Solved... Edit Post link doesn't take me anywhere.
=A1+7-WEEKDAY(A1+2,2) -- this is the answer. It works. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks