date conversion

  • Thread starter Thread starter function newbie
  • Start date Start date
F

function newbie

can a date be converted into the current year.
ie: cell a1 = 1/9/95 cell b2 should = 1/9/03
 
=DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))

of course 02/29/00 will return 03/01/03
 
=+TEXT(MONTH(A1)&"/"&DAY(A1)&"/"&2003,"dd/mm/yy")

that appears to work..
 
You must log in or register to reply here.

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

Which is the best MBOX Converter Tool different formats conversion? 4
Problem formatting dates from CSV file 2
Date/Time 1
date & Time 1
Date Formula 85 factor 7
Converting from Decimal to Base-36 in Excel Formula 8
Comparison of columns using Conditional Formatting 3
How to extract a character from a string then VLOOKUP a table? 7

Back
Top