extract date and current year

[Howardc1001]

I have dates in col B (format dd/mm/yyyy) and the current date in E1


I want to extract the day and month from Col B and the year from E1 in Col C, but cannot get it to work

I have should what the end result should look like in Col D

it would be appreciated if someone could assist me

[AliGW]

This is what you need:

=DATE(YEAR(E1),MONTH(B4),DAY(B4))

Or this:

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

[Phuocam]

Try

=DATE(YEAR($E$1),MONTH(B4),DAY(B4))

[Pete_UK]

You can use this in D4:

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

then copy down.

Hope this helps.

Pete

[Phuocam]

Or try

=EDATE(B4,(YEAR($E$1)-YEAR(B4))*12)

[Bo_Ry]

Please try this depend on your region setting

=--TEXT(B4,"d/m")
or
=--TEXT(B4,"m/d")

and format to date
Leave year blank will take current year.

[avk]

Please Login or Register  to view this content.

[Howardc1001]

thanks for the help guys