Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find the date of the coming up Saturday given the current date.
I'm trying to figure out a formula that will return the date of the
coming up saturday given the current date. For instance if the current date is 4/10/2007, I want the formula to return 4/14/2007 which is the next saturday. If the current date is 4/9/2007, I want the formula to return 4/14/2007. thanks in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find the date of the coming up Saturday given the current date.
=A1+7-WEEKDAY(A1)
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Michael Ermino" wrote in message oups.com... I'm trying to figure out a formula that will return the date of the coming up saturday given the current date. For instance if the current date is 4/10/2007, I want the formula to return 4/14/2007 which is the next saturday. If the current date is 4/9/2007, I want the formula to return 4/14/2007. thanks in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find the date of the coming up Saturday given the current date.
Something like this:
=A1+(6-Weekday(A12)) -- Rodrigo Ferreira "Michael Ermino" escreveu na mensagem oups.com... I'm trying to figure out a formula that will return the date of the coming up saturday given the current date. For instance if the current date is 4/10/2007, I want the formula to return 4/14/2007 which is the next saturday. If the current date is 4/9/2007, I want the formula to return 4/14/2007. thanks in advance. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find the date of the coming up Saturday given the current date.
Hi
Assuming your date is in cell A1 =A1+7-WEEKDAY(A1) Will give you the coming saturday HTH :-) -- _______________________ Naz, London "Michael Ermino" wrote: I'm trying to figure out a formula that will return the date of the coming up saturday given the current date. For instance if the current date is 4/10/2007, I want the formula to return 4/14/2007 which is the next saturday. If the current date is 4/9/2007, I want the formula to return 4/14/2007. thanks in advance. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find the date of the coming up Saturday given the current date.
On 10 Apr 2007 16:29:34 -0700, "Michael Ermino" wrote:
I'm trying to figure out a formula that will return the date of the coming up saturday given the current date. For instance if the current date is 4/10/2007, I want the formula to return 4/14/2007 which is the next saturday. If the current date is 4/9/2007, I want the formula to return 4/14/2007. thanks in advance. It depends on what you want to do if the "current date" is a Saturday. If you want to return the SAME day (4/14/2007 -- 4/14/2007) then, as others have written: =A1+7-WEEKDAY(A1) However, if, as you write, you want to return the NEXT Saturday (4/14/2007 -- 4/21/2007) then: =A1+7-MOD(WEEKDAY(A1),7) --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determine next Saturday based on a given date | Excel Worksheet Functions | |||
Workday return a Saturday date | Setting up and Configuration of Excel | |||
Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
Function to find row with most current date | Excel Worksheet Functions | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions |