Hello,
I have a question on how to return a Sunday Weekending based on the number of weeks in column A1. For example, if column A1 = 4 then I need to return weekening in column B1 as 03/06/2014 if today is 02/17/2014.
Thanks for your help.
Hello,
I have a question on how to return a Sunday Weekending based on the number of weeks in column A1. For example, if column A1 = 4 then I need to return weekening in column B1 as 03/06/2014 if today is 02/17/2014.
Thanks for your help.
So you have two inputs:
1) TODAY
2) Number of weeks
And you want to find the sunday of the week ending a number of weeks from today, right?
Well, basically I'd do something like this:
Given:
A1 = number_of_weeks
Then:
B1 = TODAY() + A1 *7
And then modify up/down to message to the week-ending date.
What's the rule for that anyway? Do you want the Sunday or Friday closest to then either way, or the first after that, or the last one before the "target date"?
Your example is "four weeks from today", but the example output is the thursday of week-after-next, a mere 17 days away.
hi,
do you really mean 03/06/2014, or 03/16/2014 ?
rgds,
AL
Try this formula
=TODAY()+A1*7-WEEKDAY(TODAY()-1)
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks