If cell A1 contains a value (any value at all, as long as it is not blank) then convert the date in cell B1 to American format (eg. 31/12/2014 becomes 12/31/2014). The formula for this would be in cell C1. I need a formula as I have A LOT of data :o
I would be extremely thankful if anyone could help with this please!
Not sure if this will work
try
=IF(A1<>"",MONTH(B1)&"/"&DAY(B1)&"/"&YEAR(B1),"")
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Try following C1
Formula:
=if(A1<>"",Text(B1,"MM/DD/YYYY"),"")
or
Formula:=if(A1<>"",Text(Datevalue(B1),"MM/DD/YYYY"),"")
Note:-
However, you can also consider changing the Format your windows date format in Data and Time Settings.
It will automatically change the date format of your excel file.
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
In C1
Formula:=IF(A1<>"",B1)
Format C1 as mm/dd/yyy
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Perfect answers, thanks guys!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks