Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Entering week ending dates
I want to be able to put enter a date when we started working on a job. Then
off of that date I want to fill in week ending dates in several other cells. for example: If I put in Aug 1, 2007, then in the first of the weekending cells I would want the date of Aug 3, 2007, the next cell Aug 10, 2007 and so on. The begining date can vary so it might be Aug 6, 2007. Is there a formula that can figure this out? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Entering week ending dates
the try:
in B1: =A1+(6-WEEKDAY(A1,1)) A1=Start Date Add 7 to the above date to get next Friday C1=B1+7 etc "Jenilise" wrote: I want to be able to put enter a date when we started working on a job. Then off of that date I want to fill in week ending dates in several other cells. for example: If I put in Aug 1, 2007, then in the first of the weekending cells I would want the date of Aug 3, 2007, the next cell Aug 10, 2007 and so on. The begining date can vary so it might be Aug 6, 2007. Is there a formula that can figure this out? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Entering week ending dates
=A1+MOD(6-WEEKDAY(A1),7) in A2, then =A2+7 and onwards
-- David Biddulph "Jenilise" wrote in message ... I want to be able to put enter a date when we started working on a job. Then off of that date I want to fill in week ending dates in several other cells. for example: If I put in Aug 1, 2007, then in the first of the weekending cells I would want the date of Aug 3, 2007, the next cell Aug 10, 2007 and so on. The begining date can vary so it might be Aug 6, 2007. Is there a formula that can figure this out? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Entering week ending dates
Thank you so much..
"Jenilise" wrote: I want to be able to put enter a date when we started working on a job. Then off of that date I want to fill in week ending dates in several other cells. for example: If I put in Aug 1, 2007, then in the first of the weekending cells I would want the date of Aug 3, 2007, the next cell Aug 10, 2007 and so on. The begining date can vary so it might be Aug 6, 2007. Is there a formula that can figure this out? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Week Ending formula | Excel Discussion (Misc queries) | |||
Week Ending Reports | Excel Discussion (Misc queries) | |||
AVG row of data by Week ending | Excel Discussion (Misc queries) | |||
How to format cells to show dates as the week-ending date of that | Excel Worksheet Functions | |||
Week ending | Excel Worksheet Functions |