Year-to-date return
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" wrote in message ... 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 |
All times are GMT +1. The time now is 01:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com