Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Return 1st of the Month
I need a formula or function which will return the first of the month. For
example, if Cell c4 contains 2/15/05, i need to return 2/01/05 in cell d4. Cell c4 can contain any date. |
#2
|
|||
|
|||
=date(year(c4),month(c4),1)
-- HTH RP (remove nothere from the email address if mailing direct) "JJalomo" wrote in message ... I need a formula or function which will return the first of the month. For example, if Cell c4 contains 2/15/05, i need to return 2/01/05 in cell d4. Cell c4 can contain any date. |
#3
|
|||
|
|||
=DATE(YEAR(C4),MONTH(C4),1)
-- Regards, Peo Sjoblom "JJalomo" wrote in message ... I need a formula or function which will return the first of the month. For example, if Cell c4 contains 2/15/05, i need to return 2/01/05 in cell d4. Cell c4 can contain any date. |
#4
|
|||
|
|||
=date(year(c4),month(c4),1)
HTH, Gary Brown "JJalomo" wrote: I need a formula or function which will return the first of the month. For example, if Cell c4 contains 2/15/05, i need to return 2/01/05 in cell d4. Cell c4 can contain any date. |
#5
|
|||
|
|||
=date(year(c4),month(c4),1)
HTH, Gary Brown "JJalomo" wrote: I need a formula or function which will return the first of the month. For example, if Cell c4 contains 2/15/05, i need to return 2/01/05 in cell d4. Cell c4 can contain any date. |
#6
|
|||
|
|||
Try...
=DATE(YEAR(C4),MONTH(C4),1) Hope this helps! In article , "JJalomo" wrote: I need a formula or function which will return the first of the month. For example, if Cell c4 contains 2/15/05, i need to return 2/01/05 in cell d4. Cell c4 can contain any date. |
#7
|
|||
|
|||
=SUM(C4,-DAY(C4),1)
HTH Jason Atlanta, GA -----Original Message----- I need a formula or function which will return the first of the month. For example, if Cell c4 contains 2/15/05, i need to return 2/01/05 in cell d4. Cell c4 can contain any date. . |
#8
|
|||
|
|||
On Tue, 1 Mar 2005 09:19:07 -0800, "JJalomo"
wrote: I need a formula or function which will return the first of the month. For example, if Cell c4 contains 2/15/05, i need to return 2/01/05 in cell d4. Cell c4 can contain any date. =c4-day(c4)+1 --ron |
#9
|
|||
|
|||
Thank you all. I now have several options which work.
"JJalomo" wrote: I need a formula or function which will return the first of the month. For example, if Cell c4 contains 2/15/05, i need to return 2/01/05 in cell d4. Cell c4 can contain any date. |
#10
|
|||
|
|||
You could also use =eomonth(c4,-1)+1
"JJalomo" wrote: I need a formula or function which will return the first of the month. For example, if Cell c4 contains 2/15/05, i need to return 2/01/05 in cell d4. Cell c4 can contain any date. |
#11
|
|||
|
|||
Sorry to intrude, I need a similar function but will always return the start
date of the CURRENT month - i.e date sheet is opened? I tried using TODAY() in place of C4 in this formula but no luck - any suggestions? Matt "Gary Brown" wrote: =date(year(c4),month(c4),1) HTH, Gary Brown "JJalomo" wrote: I need a formula or function which will return the first of the month. For example, if Cell c4 contains 2/15/05, i need to return 2/01/05 in cell d4. Cell c4 can contain any date. |
#12
|
|||
|
|||
Sorry - seems to work now, what sure what the problem was earlier.
Cheers, Matt "Matt D Francis" wrote: Sorry to intrude, I need a similar function but will always return the start date of the CURRENT month - i.e date sheet is opened? I tried using TODAY() in place of C4 in this formula but no luck - any suggestions? Matt "Gary Brown" wrote: =date(year(c4),month(c4),1) HTH, Gary Brown "JJalomo" wrote: I need a formula or function which will return the first of the month. For example, if Cell c4 contains 2/15/05, i need to return 2/01/05 in cell d4. Cell c4 can contain any date. |
#13
|
|||
|
|||
On Wed, 18 May 2005 06:48:03 -0700, "Matt D Francis"
wrote: Sorry to intrude, I need a similar function but will always return the start date of the CURRENT month - i.e date sheet is opened? I tried using TODAY() in place of C4 in this formula but no luck - any suggestions? Matt =A1-DAY(A1)+1 Substitute TODAY() for A1. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add one month to the previuos month | Excel Discussion (Misc queries) | |||
Month Year Date Format | Excel Worksheet Functions | |||
Accounting Month vs. Calendar Month | Excel Worksheet Functions | |||
How to extract month number from month name | Excel Discussion (Misc queries) | |||
Return the end of month date from a date | Excel Worksheet Functions |