FAQ Off Excel Experts
#6
(05-05-2023, 03:28 PM)Fido Wrote:
(05-05-2023, 02:45 PM)AnelkasBeard Wrote: You'd just have to use a combination of IF statements based on the data set. So if saturday do this, if sunday do this etc

Surely you could get that from a formula based on the date I.e. if it’s 05/05/2023 it’ll know it’s a Friday anyway? 

This is from someone who knows VLOOKUP, CONCAT and fugg all else!

Yeah just use WEEKDAY, which gives you the day of the week from the date. But then you have to tell excel what to do next. It's certainly doable, slightly finicky because it uses time.

Also, start using XLOOKUP instead of VLOOKUP, much easier to do.
Reply


Messages In This Thread
FAQ Off Excel Experts - by MrFizz - 05-05-2023, 01:06 PM
RE: FAQ Off Excel Experts - by Calgary_Baggie - 05-05-2023, 01:54 PM
RE: FAQ Off Excel Experts - by AnelkasBeard - 05-05-2023, 02:45 PM
RE: FAQ Off Excel Experts - by Fido - 05-05-2023, 03:28 PM
RE: FAQ Off Excel Experts - by Calgary_Baggie - 05-05-2023, 04:06 PM
RE: FAQ Off Excel Experts - by MassDebater - 05-05-2023, 03:13 PM
RE: FAQ Off Excel Experts - by AnelkasBeard - 05-05-2023, 03:41 PM
RE: FAQ Off Excel Experts - by MrFizz - 05-05-2023, 03:46 PM

Forum Jump:


Users browsing this thread: