Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto enter date?
Hi! me again!
is there any way i can get excel to auto enter dates that jump by 7 days every 7th cell along? cheers steve |
#2
|
|||
|
|||
Ive worked part of this out.
in cell G1 =DATE(105,1,3) in cell M1 =G1+(WEEKDAY(G1)=1)*7-WEEKDAY(G1)+1 but its displaying the time...i just want the date.... steve "R.P.McMurphy" wrote in message ... Hi! me again! is there any way i can get excel to auto enter dates that jump by 7 days every 7th cell along? cheers steve |
#3
|
|||
|
|||
wehey! im doing this all by myself now...with the aid of google!
steve "R.P.McMurphy" wrote in message ... Hi! me again! is there any way i can get excel to auto enter dates that jump by 7 days every 7th cell along? cheers steve |
#4
|
|||
|
|||
Your formula returns 9/1/2005 for me which, by my way of counting, is a jump
of 6 days not seven. If by 'auto enter dates' you mean a formula that it can be dragged along, try: =IF(MOD(COLUMN()-COLUMN($G$1),6)=0,$G$1+COLUMN()-COLUMN($G$1),"") or am I missing something? -- Regards Sandy Replace@mailinator with @tiscali.co.uk "R.P.McMurphy" wrote in message ... Ive worked part of this out. in cell G1 =DATE(105,1,3) in cell M1 =G1+(WEEKDAY(G1)=1)*7-WEEKDAY(G1)+1 but its displaying the time...i just want the date.... steve "R.P.McMurphy" wrote in message ... Hi! me again! is there any way i can get excel to auto enter dates that jump by 7 days every 7th cell along? cheers steve |
#5
|
|||
|
|||
I used
=S1+(WEEKDAY(S1)=2)*8-WEEKDAY(S1)+1 which works ok. i just copy it to the next cell along. steve "Sandy Mann" wrote in message ... Your formula returns 9/1/2005 for me which, by my way of counting, is a jump of 6 days not seven. If by 'auto enter dates' you mean a formula that it can be dragged along, try: =IF(MOD(COLUMN()-COLUMN($G$1),6)=0,$G$1+COLUMN()-COLUMN($G$1),"") or am I missing something? -- Regards Sandy Replace@mailinator with @tiscali.co.uk "R.P.McMurphy" wrote in message ... Ive worked part of this out. in cell G1 =DATE(105,1,3) in cell M1 =G1+(WEEKDAY(G1)=1)*7-WEEKDAY(G1)+1 but its displaying the time...i just want the date.... steve "R.P.McMurphy" wrote in message ... Hi! me again! is there any way i can get excel to auto enter dates that jump by 7 days every 7th cell along? cheers steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date auto change | Excel Discussion (Misc queries) | |||
Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
auto dating after entering the first date | Excel Worksheet Functions | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
assign auto number and auto date | Excel Discussion (Misc queries) |