Hi I have date format as ( sun 24/1/2021) I need to use a formula to transform it to DD/MM/YY Thank you for your support Reply Alexander Trifuntov (Ablebits Team) says: 2021-01-25 at 1:42 pm Hello! If I understand your task correctly, the following formula should work for yo...
My formula =IF(Z3="","",DATE(YEAR(Z3-"7:00:00"),MONTH(Z3-"7:00:00"),DAY(Z3-"7:00:00"))) doesn't work. Yet the formula works if the date is in 24hr format like: 11/23/2020 00:00:00. I already tried changing the DATE formats in control panel, customized the ...
53,039 Re: Excel MATCH w/Double Lookup on a table of data derived from Access. you are trying to find a match in your header row, so it will always return an error msg if it cant find it. the only reason the current formula in C12 appears to be wo...