How to get the dates of the current monday, wednesday and friday of the current week in excel?
Fresh3 days ago
Mar 15, 202661719 viewsConfidence Score0%
0%
Problem
I'd just like a simple formula to return the date for the current Monday, Wednesday and Friday based on the current date. So, I would like to see it like: Cell A1 I'd like (Today is Monday January 9 2012) Cell B1 I'd like (Wednesday January 11 2012) Cell C1 I'd like (Friday January 13 2012).
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How to get the dates of the current monday, wednesday and friday of the current week in excel?
Low Risk
The following will display the dates for Monday, Wednesday and Friday of the current week: Basically this is taking the time now, and subtracting the current weekday (which gives you Monday), then adds 2 days or 4 days to get Wednesday and Friday.
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix