| 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: |
| Quickly Typing Dates into Cells | |
|---|---|
| Tweet Topic Started: Nov 16 2006, 05:49 PM (172 Views) | |
| Ahmaq | Nov 16 2006, 05:49 PM Post #1 |
![]()
Hum sa ho to saamnay a'ay
![]()
|
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 |
![]() |
|
| Deleted User | Dec 6 2006, 08:42 PM Post #2 |
|
Deleted User
|
MASHALLAH g aap key class aachi ja rahe hai g |
|
|
| Asim | Dec 16 2006, 07:53 AM Post #3 |
|
Per Dada/Per Dadi
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]()
|
gr8: |
![]() |
|
| Deleted User | Dec 16 2006, 08:55 AM Post #4 |
|
Deleted User
|
next g |
|
|
| 1 user reading this topic (1 Guest and 0 Anonymous) | |
| « Previous Topic · Roshnee · Next Topic » |










![]](http://z5.ifrm.com/static/1/pip_r.png)
5:33 AM Jul 11