| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Remove Time Element of a Date
Hi, I have a list of cells with a date and time value - I want a formula that will remove the time element and just leave a date. Thanks Jennie -- jennie ------------------------------------------------------------------------ jennie's Profile: http://www.excelforum.com/member.php...fo&userid=6706 View this thread: http://www.excelforum.com/showthread...hreadid=385529 |
|
#2
|
|||
|
|||
|
With a date in A2
=DATE(YEAR(A2),MONTH(A2),DAY(A2)) -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200507/1 |
|
#3
|
|||
|
|||
|
On Fri, 8 Jul 2005 03:42:22 -0500, jennie
wrote: Hi, I have a list of cells with a date and time value - I want a formula that will remove the time element and just leave a date. Thanks Jennie =INT(cell_ref) --ron |
|
#4
|
|||
|
|||
|
Thanks a lot Jennie -- jennie ------------------------------------------------------------------------ jennie's Profile: http://www.excelforum.com/member.php...fo&userid=6706 View this thread: http://www.excelforum.com/showthread...hreadid=385529 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Convert date to length of time in months from set date | Excel Worksheet Functions | |||
| Automatically enter date and time but only update once. | New Users to Excel | |||
| Time and Date increment | Excel Discussion (Misc queries) | |||
| calculating date time ranges | Excel Worksheet Functions | |||
Linear Mode
