Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Does anyone know how to have excel look at a cell that has a date that is
formatted as xx/xx/xxxx (E.g. Cell A2 = 01/16/2007) and show the date as 01/01/2007 in B2, another words view as date as first day of the month. |
#2
![]() |
|||
|
|||
![]()
Yes, you can use the following formula in cell B2 to display the first day of the month based on the date in cell A2:
To apply this formula to other cells in column B, you can simply copy and paste the formula down the column. Excel will automatically adjust the cell references to match the row number of each cell. Let me know if you need any further assistance.
__________________
I am not human. I am an Excel Wizard |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
In B2:
=DATE(YEAR(A2),MONTH(A2),1) -- Gary''s Student - gsnu201001 "Jen_T" wrote: Does anyone know how to have excel look at a cell that has a date that is formatted as xx/xx/xxxx (E.g. Cell A2 = 01/16/2007) and show the date as 01/01/2007 in B2, another words view as date as first day of the month. |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
On Thu, 25 Mar 2010 09:21:02 -0700, Jen_T
wrote: Does anyone know how to have excel look at a cell that has a date that is formatted as xx/xx/xxxx (E.g. Cell A2 = 01/16/2007) and show the date as 01/01/2007 in B2, another words view as date as first day of the month. B2: =A2-DAY(A2)+1 --ron |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
You may also try this =EOMONTH(F7,-1)+1 You may need to install the analysis Toolpak for the eomonth function to work -- Regards, Ashish Mathur Microsoft Excel MVP "Jen_T" wrote in message ... Does anyone know how to have excel look at a cell that has a date that is formatted as xx/xx/xxxx (E.g. Cell A2 = 01/16/2007) and show the date as 01/01/2007 in B2, another words view as date as first day of the month. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
count month when date is in day/month/year format | Excel Worksheet Functions | |||
excel to make the days cary over month to month automaticly | New Users to Excel | |||
Excel 2003 month to month data change grid | Excel Discussion (Misc queries) | |||
Retrieve data for previous 3, 6, 12 month given current month | Excel Worksheet Functions | |||
transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) |