formula using dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
=DATE(YEAR(TODAY(),MONTH(A1),DAY(A1))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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?
 
=date(year(today()),month(A1),day(A1))

if A1 contains the hire date, this should work.

Sam
 

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

Similar Threads

Date formula 3
using datedif formula 2
(YEARS) Excel Formula 2
Payroll Forecast Calc 2
is there a formula that will subtract todays date from a hire date 4
copy formula 3
IF and DATE Formula Help PLEASE 6
Calculate a Date 6

Back
Top