| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates ... advance 1 Month @ a Time
Excel2003 ... I want to enter 01/01/07 in Cell A1 and then have Range B1:L11
values be 02/01/07, 03/01/07, 04/01/07 etc etc ... After this I will chg my format to suit. How do I properly write this Date formula ... Thanks ... Kha |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates ... advance 1 Month @ a Time
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Ken" wrote in message ... Excel2003 ... I want to enter 01/01/07 in Cell A1 and then have Range B1:L11 values be 02/01/07, 03/01/07, 04/01/07 etc etc ... After this I will chg my format to suit. How do I properly write this Date formula ... Thanks ... Kha |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates ... advance 1 Month @ a Time
. ... or put first two dates in A1 & B1, highlight and drag across to L1
"Bernard Liengme" wrote: =DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Ken" wrote in message ... Excel2003 ... I want to enter 01/01/07 in Cell A1 and then have Range B1:L11 values be 02/01/07, 03/01/07, 04/01/07 etc etc ... After this I will chg my format to suit. How do I properly write this Date formula ... Thanks ... Kha |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates ... advance 1 Month @ a Time
Actually ... EDATE(A1,1) ... got me there ...
Initially, I was trying formulas similar to Bernards & I was failing ... However, these clarifications will come in handy ... Thanks for the guidance .... Kha "Toppers" wrote: . ... or put first two dates in A1 & B1, highlight and drag across to L1 "Bernard Liengme" wrote: =DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Ken" wrote in message ... Excel2003 ... I want to enter 01/01/07 in Cell A1 and then have Range B1:L11 values be 02/01/07, 03/01/07, 04/01/07 etc etc ... After this I will chg my format to suit. How do I properly write this Date formula ... Thanks ... Kha |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates for month in cell a1 downwards | Excel Worksheet Functions | |||
| Count the dates in a month | Excel Discussion (Misc queries) | |||
| Dates - Several Days In a month to month only | Excel Discussion (Misc queries) | |||
| dates in one month | Excel Worksheet Functions | |||
| dates, 1st of month | Excel Worksheet Functions | |||
Linear Mode
