Year-to-date return

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top