Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Creating Spreadsheet with Date Formula
I need to create a spreadsheet which has a beginning date, 02.10.09 and then
from that date adds, 24 hours, a 4-6 week date range, a 8-10 week range, etc. Can someone help me get started? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Creating Spreadsheet with Date Formula
One way:
A1: 02.10.09 Add 24 hours: A2: =A1+1 4-6 week date range: A3: =TEXT(A1+28,"mm.dd.yyyy") & "-" & TEXT(A1+42,"mm.dd.yyyy") 8-10 week date range: A4: =TEXT(A1+56,"mm.dd.yyyy") & "-" & TEXT(A1+70,"mm.dd.yyyy") In article , Jschaeffel wrote: I need to create a spreadsheet which has a beginning date, 02.10.09 and then from that date adds, 24 hours, a 4-6 week date range, a 8-10 week range, etc. Can someone help me get started? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Creating Spreadsheet with Date Formula
Hi,
Suppose your start date is in A1 then in B1 enter =A1+1 In C1 enter =A1+7*4 In D1 enter =A1+7*8 Select C1:D1 copy them and chose Edit, Paste Special Values. Highlight C1:D1 and using the Fill Handle drag down 14 rows or 21 depending on what exactly you want. When you release the mouse if Excel has copied the data, click the paste options icon, usually at the bottom right of the selection, and choose Fill Days. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Jschaeffel" wrote: I need to create a spreadsheet which has a beginning date, 02.10.09 and then from that date adds, 24 hours, a 4-6 week date range, a 8-10 week range, etc. Can someone help me get started? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a master spreadsheet | Excel Discussion (Misc queries) | |||
Creating a spreadsheet | Excel Discussion (Misc queries) | |||
Creating a formula to show year to date total. | Excel Discussion (Misc queries) | |||
Change Year Date In A Formula Throughout The Spreadsheet | Excel Discussion (Misc queries) | |||
In creating a spreadsheet how can I lock a formula cell only? | New Users to Excel |