Year-to-date return

Maybe this

=DATE(YEAR(A1)-1,12,31)
Or
=DATE(YEAR(A1),1,1)-1

--
Regards Ron de Bruin
http://www.rondebruin.nl


"RussG" <RussG@discussions.microsoft.com> wrote in message news:7BB65C5E-4D6A-4A71-8874-48FC9E62D5C7@microsoft.com...
> Hello,
> I would like to return a date = to previous year end, based on a referenced
> cell. For example, if reference cell = 9/30/04, my formula will return
> 12/31/03. If reference cell = 3/31/05, formula will return 12/31/04. I know
> how to do this in Access using dateadd function, but can it be done in Excel
> (using edate, for example)?
> Thanks in advance for your help!
> -Russ

Maybe this

=DATE(YEAR(A1)-1,12,31)
Or
=DATE(YEAR(A1),1,1)-1

--
Regards Ron de Bruin
http://www.rondebruin.nl


"RussG" <RussG@discussions.microsoft.com> wrote in message news:7BB65C5E-4D6A-4A71-8874-48FC9E62D5C7@microsoft.com...
> Hello,
> I would like to return a date = to previous year end, based on a referenced
> cell. For example, if reference cell = 9/30/04, my formula will return
> 12/31/03. If reference cell = 3/31/05, formula will return 12/31/04. I know
> how to do this in Access using dateadd function, but can it be done in Excel
> (using edate, for example)?
> Thanks in advance for your help!
> -Russ

Hello,
I would like to return a date = to previous year end, based on a referenced
cell. For example, if reference cell = 9/30/04, my formula will return
12/31/03. If reference cell = 3/31/05, formula will return 12/31/04. I know
how to do this in Access using dateadd function, but can it be done in Excel
(using edate, for example)?
Thanks in advance for your help!
-Russ

Maybe this

=DATE(YEAR(A1)-1,12,31)
Or
=DATE(YEAR(A1),1,1)-1

--
Regards Ron de Bruin
http://www.rondebruin.nl


"RussG" <RussG@discussions.microsoft.com> wrote in message news:7BB65C5E-4D6A-4A71-8874-48FC9E62D5C7@microsoft.com...
> Hello,
> I would like to return a date = to previous year end, based on a referenced
> cell. For example, if reference cell = 9/30/04, my formula will return
> 12/31/03. If reference cell = 3/31/05, formula will return 12/31/04. I know
> how to do this in Access using dateadd function, but can it be done in Excel
> (using edate, for example)?
> Thanks in advance for your help!
> -Russ