| Column A | Column B | | 14/4 | 1 | | 15/4 | 100 | | 16/4 | 70 | | 17/4 | 80 | What is the formula I could use to extract the data (column B) of previous weekday please? So if I open the file on monday (17 april), formula… Read More Excel: how to return data of the last weekday?

So i wanted the user to enter date and based on that day to get named day of the week, for example today’s date is 2022.11.10, so wanted answer would be Thursday. I know this is wrong, can anybody help? import datetime def dayOfTheWeek(day, month, year): date = datetime.date(year, month, day) weekday = date.weekday() day_dict… Read More How to get day of the week based on inputed date(Python)

I have a dataset that contains DateTime in (dd-mm-yy hh: mm) format. I want to find the weekday number? I have tried the weekday function, but it is showing the wrong output. wday("13-06-21 19:32") 6 >Solution : The datetime is not in the POSIXct class i.e. it is just character class. We need to convert… Read More How to find weekday number from datetime format in R