ExcelBanter - formula using dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - formula using dates (https://www.excelbanter.com/excel-worksheet-functions/163677-formula-using-dates.html)

bookish

formula using dates

I have an excel sheet with hire dates in one column and I need a formula that
will return the same month and day as the hire date but with the current
year. Any ideas?

Niek Otten

formula using dates

=DATE(YEAR(TODAY(),MONTH(A1),DAY(A1))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"bookish" wrote in message ...
|I have an excel sheet with hire dates in one column and I need a formula that
| will return the same month and day as the hire date but with the current
| year. Any ideas?

Sam Wilson

formula using dates

=date(year(today()),month(A1),day(A1))

if A1 contains the hire date, this should work.

Sam

"bookish" wrote:

I have an excel sheet with hire dates in one column and I need a formula that
will return the same month and day as the hire date but with the current
year. Any ideas?

All times are GMT +1. The time now is 02:21 PM.