Excel: how to return data of the last weekday?
| 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 should return 1. If I open the file on tuesday (18 apr), formula should return 80.
Thanks in advance for your help.
Solution
- What is the equivalent of the "Days" function or number of days between 2 dates in excel 2007?
- Need help aligning a table to a column based on similar values in one table field
- Index rows and columns unexpected results
- Automatic numbering in Excel with hierarchy
- How to do a row-wise sum in an array formula in Excel?
- Transform datatable from column-based to row-based
- Combine most recent 5 records into one cell in Excel
- Matching multiple number rows and check corresponding dates within 90 days
- Sum all cells for which corresponding cell is not a formula and doesn't return #VALUE AND date occurs in the past
- How can I use countif to return only a count if sum is > 0 but only count it once
- excel No of hours in a shift
- How do transform a "matrix"-table to one line for each entry in excel
- How to fill fast for integer number calculation?
- Find Corresponding Value Based on Today's Date Falling Between Week-Ending Dates in Excel
- Date format issue when I try to find the first occurrence of names with associated dates
- Excel - How can we replace multiple characters or whole words in a cell using LAMBDA()
- Nested if statements in EXCEL dependent on first condition
- List only workdays in given dynamic month
- INDIRECT array to refer to a table column not working with array formulas
- Putting a concatenate inside of a count if
- Excel: how to search by two rows and one column
- Excel - Check existing digit count, if <10 then add prefix "100" to make it 10 digit
- Custom Excel formula for length restriction of substring within a string in a cell
- COUNTIFS across multiple columns with multiple criteria
- Occurrence by month using Excel Functions
- Strange behavior in Excel when counting Work Hours and Work Super Hours
- Need help fixing my excel formula so it doesn't show #VALUE! error in end result
- Can I guarantee the Image Formula Function is finished before printing the result?
- Excel filter data in date intervals excluding all 0 values
- Count cells with two conditions