Register now or log in to join your professional community.
Example: * If the cell "A1" contains:01/01/2001 And you want to fix (06/04) of the same year in the cell "B1", i.e. the value in "B1" should be:06/04/2001 another example: * If the cell "A1" contains:15/09/2015 "B1" will be:06/04/20153rd example: If "A1" is13/02/2009 -> "B1" will be:06/04/2009
Try this formula: ="6/4/"&YEAR(A1)
Note: A1 should be the cell that contains your information reference. So if you're typing at C1, your formula shoud be ="6/4/"&YEAR(C1).
=DATE(YEAR(A1),6,4)
Great answers.
Try this formula: =DATE(YEAR(A1);4;6)
Any other ideas? :)
="6/4/"&YEAR(A1)
Type in B1
="6/4/"&YEAR(A1)
OR
=TEXT(("6/4/"&YEAR(A1)),"dd/mm/yy")
after you fix the date in the first cell, click on the next cell and put the equation (the first cell +365 or366 if the next year is leap year)
Dear Sir,
Your Date column selecting after right button pressing your mouse. when coming some details select the format Cell After selecting the Text. Which one you want here come to that
I Agreed with most answers
="6/4/"&YEAR(A1)
simple as it
="6/4/ "&YEAR(A1)
or using Concatenate
=CONCATENATE("6","/",4,"/",YEAR(A1))
OR
=CONCATENATE("6","/","April","/",YEAR(A1))also Making a Format of the Cell Use CTRL+1 and format date accordindly
