| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
First Day of the Month
Is there a function or a way that I can look at a cell (A2) in date format
and pull in the first day of the month in B2. Example: A B 12/25/2009 12/1/2009 5/19/2009 5/1/2009 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
First Day of the Month
Hi there.
Please, try: =DATE(YEAR(A2),MONTH(A2),1) Regards, Otávio "Jen_T" wrote: Is there a function or a way that I can look at a cell (A2) in date format and pull in the first day of the month in B2. Example: A B 12/25/2009 12/1/2009 5/19/2009 5/1/2009 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
First Day of the Month
On Mon, 14 Dec 2009 05:21:02 -0800, Jen_T
wrote: Is there a function or a way that I can look at a cell (A2) in date format and pull in the first day of the month in B2. Example: A B 12/25/2009 12/1/2009 5/19/2009 5/1/2009 =a1+1-day(a1) --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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) | |||
| Create Month Timetable on a worksheet different month each works | Excel Worksheet Functions | |||
| When using MONTH function on Blank Cell!! Returns Month=Jan! | Excel Discussion (Misc queries) | |||
| transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) | |||
Hybrid Mode
