Excel: how to return data of the last weekday?

Question

| 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.

Column A also has the year? – Darren Bartrup-Cook Apr 06 '23 at 12:27 — Darren Bartrup-Cook, Apr 06 '23 at 12:27
Yep it also has year. So it should fully be 17/4/2023. – Mini Muc Apr 06 '23 at 12:34 — Mini Muc, Apr 06 '23 at 12:34

score 2 · Accepted Answer · answered Apr 06 '23 at 12:39

2

With your data in A1:B6 use the formula =XLOOKUP(WORKDAY(TODAY(),-1),$A$1:$A$6,$B$1:$B$6)

WORKDAY

answered Apr 06 '23 at 12:39

Darren Bartrup-Cook

18,362
1
23
45

Excel: how to return data of the last weekday?

1 Answers1