DATES

verluc · May 15th, 2002, 08:36 AM

I have a sheet filled with dates in row 2
Ex. C 15.05.2002
D 14.05.2002
E 13.05.2002
F 10.05.2002
G 09.05.2002
end so on ....
Each day I added one date in column C and all the other days move one column to the right.(I added one column.)
Now I want to have on the upperside of my sheet the total period of all this dates:
Ex. 09.05.2002 / 15.05.2002
15.05.2002 is the date of column C and 09.05.2002 is the date of the last used column.
Who can write me a macro to do this each day autmaticly ?
Thanks in advance

Asala42 · May 15th, 2002, 08:49 AM

G'day,

Can you get away with a formula? Something like:

=TEXT(MIN(2:2),"mm/dd/yy")&" - "&TEXT(MAX(2:2),"mm/dd/yy")

(Tweak the format to your needs)

Adam

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 15th, 2002, 08:36 AM	#1
verluc Board Regular Join Date: Mar 2002 Posts: 1,290	I have a sheet filled with dates in row 2 Ex. C 15.05.2002 D 14.05.2002 E 13.05.2002 F 10.05.2002 G 09.05.2002 end so on .... Each day I added one date in column C and all the other days move one column to the right.(I added one column.) Now I want to have on the upperside of my sheet the total period of all this dates: Ex. 09.05.2002 / 15.05.2002 15.05.2002 is the date of column C and 09.05.2002 is the date of the last used column. Who can write me a macro to do this each day autmaticly ? Thanks in advance

May 15th, 2002, 08:49 AM	#2
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	G'day, Can you get away with a formula? Something like: =TEXT(MIN(2:2),"mm/dd/yy")&" - "&TEXT(MAX(2:2),"mm/dd/yy") (Tweak the format to your needs) Adam