| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Beginning of Year
I'm nowhere near the technical level as most of you on this site, so I'm
hoping you can help me out. Isn't there a formula you can enter in Excel that will return the first calendar year of a year? |
|
#2
|
|||
|
|||
Answer: Beginning of Year
__________________
I am not human. I am an Excel Wizard |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Beginning of Year
Not sure what you mean - could you re-phrase?
Pete On Aug 26, 10:53*pm, Lucy wrote: I'm nowhere near the technical level as most of you on this site, so I'm hoping you can help me out. Isn't there a formula you can enter in Excel that will return the first calendar year of a year? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Beginning of Year
What do you mean by calendar year? If you have a date in A1 and you want the
first date of the same year you can use =DATE(YEAR(A1),1,1) format as date -- Regards, Peo Sjoblom "Lucy" wrote in message ... I'm nowhere near the technical level as most of you on this site, so I'm hoping you can help me out. Isn't there a formula you can enter in Excel that will return the first calendar year of a year? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Beginning of Year
Put a year in A1 and in A2, enter:
=DATE(A1,1,1) then format A2 as dddd to display: Tuesday -- Gary''s Student - gsnu200801 "Lucy" wrote: I'm nowhere near the technical level as most of you on this site, so I'm hoping you can help me out. Isn't there a formula you can enter in Excel that will return the first calendar year of a year? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Beginning of Year
Sorry, clarification: I have a date in the format (mm/dd/yyyy), say in cell
H4. I wish to enter a formula, say in cell G5, that would return 01/01/yyyy of the year in cell H4. Is there such a formula? "Gary''s Student" wrote: Put a year in A1 and in A2, enter: =DATE(A1,1,1) then format A2 as dddd to display: Tuesday -- Gary''s Student - gsnu200801 "Lucy" wrote: I'm nowhere near the technical level as most of you on this site, so I'm hoping you can help me out. Isn't there a formula you can enter in Excel that will return the first calendar year of a year? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Beginning of Year
Put this in G5:
=DATE(YEAR(H4),1,1) Format the cell as you wish to see it. Hope this helps. Pete On Aug 26, 11:16*pm, Lucy wrote: Sorry, clarification: *I have a date in the format (mm/dd/yyyy), say in cell H4. *I wish to enter a formula, say in cell G5, that would return 01/01/yyyy of the year in cell H4. *Is there such a formula? "Gary''s Student" wrote: Put a year in A1 and in A2, enter: =DATE(A1,1,1) then format A2 as dddd to display: Tuesday -- Gary''s Student - gsnu200801 "Lucy" wrote: I'm nowhere near the technical level as most of you on this site, so I'm hoping you can help me out. Isn't there a formula you can enter in Excel that will return the first calendar year of a year?- Hide quoted text - - Show quoted text - |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Beginning of Year
Beautiful! Thank you.
"Pete_UK" wrote: Put this in G5: =DATE(YEAR(H4),1,1) Format the cell as you wish to see it. Hope this helps. Pete On Aug 26, 11:16 pm, Lucy wrote: Sorry, clarification: I have a date in the format (mm/dd/yyyy), say in cell H4. I wish to enter a formula, say in cell G5, that would return 01/01/yyyy of the year in cell H4. Is there such a formula? "Gary''s Student" wrote: Put a year in A1 and in A2, enter: =DATE(A1,1,1) then format A2 as dddd to display: Tuesday -- Gary''s Student - gsnu200801 "Lucy" wrote: I'm nowhere near the technical level as most of you on this site, so I'm hoping you can help me out. Isn't there a formula you can enter in Excel that will return the first calendar year of a year?- Hide quoted text - - Show quoted text - |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Beginning of Year
You're welcome, Lucy - thanks for feeding back.
Pete On Aug 26, 11:51*pm, Lucy wrote: Beautiful! Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I crate a function for week of year + year in same cell. | Excel Worksheet Functions | |||
| Combination Graph with current year and prior year sales | Charts and Charting in Excel | |||
| how to calculate $1000/year at 5% for 25 years showing each year | Setting up and Configuration of Excel | |||
| trying to get day/month/year froamt while user enters year only | New Users to Excel | |||
| Is the IRR calculation based on cash flows at beginning of year? | Excel Worksheet Functions | |||
Linear Mode
