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?

Not sure what you mean - could you re-phrase?

Pete

On Aug 26, 10:53*pm, Lucy <L...@discussions.microsoft.com> 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?

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" <(E-Mail Removed)> wrote in message
news:A822D40A-62F4-4935-AF92-(E-Mail Removed)...
> 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?

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?

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?

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 <L...@discussions.microsoft.com> wrote:
> Sorry, clarification: *I have a date in the format (mm/dd/yyyy), say incell
> 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 -

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 <L...@discussions.microsoft.com> 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 -
>
>

You're welcome, Lucy - thanks for feeding back.

Pete

On Aug 26, 11:51*pm, Lucy <L...@discussions.microsoft.com> wrote:
> Beautiful! Thank you.
>