| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) | |||
| Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
| Seed date formats to different year in different cells | Excel Discussion (Misc queries) | |||
| Month Year Date Format | Excel Worksheet Functions | |||
| Return a date 6 months from a date in another cell | Excel Worksheet Functions | |||
Linear Mode
