Date/Time Help
Hi There,
I have a cell that is a date with a time, and I'd like to be able to create another cell that is only the date and not the time. I know I can easily format the exisitng cell, however I wish to remove the time all together from the cell. I am using it to peform a sumif, which is not working because the lookup value is just 15/7/08, and the sum criteria all have a time. EG. I have "15/07/2008 11:47:59 am" which I would like to convert to simply "15/7/2008" in an adjacent cell. Hope I've explained it properly, any help would be much appreciated!! Cheers, Jane |
Date/Time Help
Try this:
A1 = 15/07/2008 11:47:59 AM To return just the date portion: =INT(A1) Format as Date -- Biff Microsoft Excel MVP "Jane" wrote in message ... Hi There, I have a cell that is a date with a time, and I'd like to be able to create another cell that is only the date and not the time. I know I can easily format the exisitng cell, however I wish to remove the time all together from the cell. I am using it to peform a sumif, which is not working because the lookup value is just 15/7/08, and the sum criteria all have a time. EG. I have "15/07/2008 11:47:59 am" which I would like to convert to simply "15/7/2008" in an adjacent cell. Hope I've explained it properly, any help would be much appreciated!! Cheers, Jane |
Date/Time Help
You are a life saver, thank you!!
"T. Valko" wrote: Try this: A1 = 15/07/2008 11:47:59 AM To return just the date portion: =INT(A1) Format as Date -- Biff Microsoft Excel MVP "Jane" wrote in message ... Hi There, I have a cell that is a date with a time, and I'd like to be able to create another cell that is only the date and not the time. I know I can easily format the exisitng cell, however I wish to remove the time all together from the cell. I am using it to peform a sumif, which is not working because the lookup value is just 15/7/08, and the sum criteria all have a time. EG. I have "15/07/2008 11:47:59 am" which I would like to convert to simply "15/7/2008" in an adjacent cell. Hope I've explained it properly, any help would be much appreciated!! Cheers, Jane |
Date/Time Help
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Jane" wrote in message ... You are a life saver, thank you!! "T. Valko" wrote: Try this: A1 = 15/07/2008 11:47:59 AM To return just the date portion: =INT(A1) Format as Date -- Biff Microsoft Excel MVP "Jane" wrote in message ... Hi There, I have a cell that is a date with a time, and I'd like to be able to create another cell that is only the date and not the time. I know I can easily format the exisitng cell, however I wish to remove the time all together from the cell. I am using it to peform a sumif, which is not working because the lookup value is just 15/7/08, and the sum criteria all have a time. EG. I have "15/07/2008 11:47:59 am" which I would like to convert to simply "15/7/2008" in an adjacent cell. Hope I've explained it properly, any help would be much appreciated!! Cheers, Jane |
All times are GMT +1. The time now is 08:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com