Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 26th 08, 10:53 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 37
Default 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   Report Post  
Old August 26th 08, 10:58 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 8,856
Default 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?


  #3   Report Post  
Old August 26th 08, 11:02 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 964
Default 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?



  #4   Report Post  
Old August 26th 08, 11:06 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,058
Default 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?

  #5   Report Post  
Old August 26th 08, 11:16 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 37
Default 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?



  #6   Report Post  
Old August 26th 08, 11:25 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 8,856
Default 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 -


  #7   Report Post  
Old August 26th 08, 11:51 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 37
Default 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 -



  #8   Report Post  
Old August 27th 08, 12:10 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 8,856
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I crate a function for week of year + year in same cell. patty ann Excel Worksheet Functions 1 March 16th 08 07:34 PM
Combination Graph with current year and prior year sales JanW Charts and Charting in Excel 2 April 5th 07 09:20 PM
how to calculate $1000/year at 5% for 25 years showing each year HELP! Setting up and Configuration of Excel 0 July 25th 06 12:58 AM
trying to get day/month/year froamt while user enters year only RADIOOZ New Users to Excel 3 June 7th 06 05:30 AM
Is the IRR calculation based on cash flows at beginning of year? sammad Excel Worksheet Functions 1 September 6th 05 05:15 PM


All times are GMT +1. The time now is 09:02 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017