Welcome Guest [Log In] [Register]
Assalamoalaikum, We hope you will enjoy your visit here.

Join our community!

If you're already a member please log in to your account to access all of our features:

Username:   Password:
Add Reply
Quickly Typing Dates into Cells
Topic Started: Nov 16 2006, 05:49 PM (172 Views)
Ahmaq
Member Avatar
Hum sa ho to saamnay a'ay
Admins
Typing a large amount of data into cells can be tiring, especially if it includes a series of dates.

Type the day (serial number only) into cell A1 and add the following formula to insert the month and year into cell B1:

=DATE (YEAR(TODAY()), MONTH(TODAY()), A1)

Type a full number in the cell and change it to a date by using the following formula:

=DATEVALUE(LEFT(A1,2)&"/"&MID(A1,3,2)&"/" &RIGHT(A1,2))

For example, type 122203, the result is 12/22/03.

See screenshot for a sample

Posted Image
Offline Profile Quote Post Goto Top
 
Deleted User
Deleted User

MASHALLAH g aap key class aachi ja rahe hai g
Quote Post Goto Top
 
Asim
Member Avatar
Per Dada/Per Dadi
[ *  *  *  *  *  * ]
gr8:
Offline Profile Quote Post Goto Top
 
Deleted User
Deleted User

next g
Quote Post Goto Top
 
1 user reading this topic (1 Guest and 0 Anonymous)
« Previous Topic · Roshnee · Next Topic »
Add Reply