FORMATING OF DATE

Mar 7th, 2002, 06:58 AM

I have a list of few hundred clients addresses and their date-of-birth and I wish to format the birthday column to reflect the year of birth to 2002 so that I can do sorting by month (use for mail merging and sending out birthday cards)

EG:
3-Mar-1946
18-May-1957
28-Sept-1967

To be formated to:
3-Mar-2002
18-May-2002
28-Sept-2002

Which formula should I use and how should the formula be keyed in.

Any help will be appreciated.

Thanks

Ricky
rlimlm@yahoo.com

Steve Hartman · Mar 7th, 2002, 07:19 AM

If your dates are in column A:

=DATE(2002,MONTH(A1),DAY(A1))

in another column and pasted down will do the trick. Of course format this column as date

Mar 7th, 2002, 07:19 AM	#2
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	If your dates are in column A: =DATE(2002,MONTH(A1),DAY(A1)) in another column and pasted down will do the trick. Of course format this column as date __________________ Veni, Vidi, Velcro - I came, I saw, I stuck around Taxation WITH representation ain't so hot either

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

Mar 7th, 2002, 06:58 AM	#1
Guest Posts: n/a	I have a list of few hundred clients addresses and their date-of-birth and I wish to format the birthday column to reflect the year of birth to 2002 so that I can do sorting by month (use for mail merging and sending out birthday cards) EG: 3-Mar-1946 18-May-1957 28-Sept-1967 To be formated to: 3-Mar-2002 18-May-2002 28-Sept-2002 Which formula should I use and how should the formula be keyed in. Any help will be appreciated. Thanks Ricky rlimlm@yahoo.com