Every Monday, I want the value in Column B to change to Actual for the previous 7 days (excluding that Monday).
For example, on 30th May, I want Column B values for 23rd to 29th May to change to Actual.
Thanks!
Every Monday, I want the value in Column B to change to Actual for the previous 7 days (excluding that Monday).
For example, on 30th May, I want Column B values for 23rd to 29th May to change to Actual.
Thanks!
In B2 copied down:
=IF(WORKDAY.INTL(A2,1,"0111111")<=TODAY(),"Actual","Forecast")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
B2=IF(TODAY()>A2-WEEKDAY(A2,2)+7,"Actual","Forecast")
Try above formula, copy and paste towards down
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks