Formating Dates
I need to update a list of dates to show all days as 01. For example, where
date shows 03/28/2009, I need it to read 03/01/2009. I appreciate any guidance! -- LL28 |
Formating Dates
On Thu, 6 May 2010 12:12:01 -0700, LovingLife28
wrote: I need to update a list of dates to show all days as 01. For example, where date shows 03/28/2009, I need it to read 03/01/2009. I appreciate any guidance! If you want to convert the dates to the first of the month, then, with your date in A1: =A1-DAY(A1)+1 If you want to leave the date as is, but merely have display as mm/01/yyyy Then custom format: mm"/01/"yyyy --ron |
Formating Dates
With the Analysis ToolPak add-in installed:
=EOMONTH(A2,-1)+1 W/o add-in: =DATE(YEAR(A2),MONTH(A2),1) -- Best Regards, Luke M "LovingLife28" wrote in message ... I need to update a list of dates to show all days as 01. For example, where date shows 03/28/2009, I need it to read 03/01/2009. I appreciate any guidance! -- LL28 |
Formating Dates
With dates in column A, In B1 enter:
=DATE(YEAR(A1),MONTH(A1),1) and copy down -- Gary''s Student - gsnu201002 "LovingLife28" wrote: I need to update a list of dates to show all days as 01. For example, where date shows 03/28/2009, I need it to read 03/01/2009. I appreciate any guidance! -- LL28 |
Formating Dates
Perfect! Thank so much!
-- LL28 "LovingLife28" wrote: I need to update a list of dates to show all days as 01. For example, where date shows 03/28/2009, I need it to read 03/01/2009. I appreciate any guidance! -- LL28 |
All times are GMT +1. The time now is 02:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com