agoodson1956
Board Regular
- Joined
- Sep 1, 2016
- Messages
- 140
Column "O" has the Award Date
Column "R" has the Bid Amount
I am trying to get Column "V" to show the Bid Amount in Column "R" only if the date in Column "O" is withing this week Sunday through Saturday and blank if not within this week?
=IFERROR(IF(WEEKNUM(TODAY())-WEEKNUM(O2)>1,"Old",IF(WEEKNUM(TODAY())-WEEKNUM(O2)>0,"Old",R2)),"")
I need it to only show SUNDAY through SATURDAY of CURRENT WEEK
Column "R" has the Bid Amount
I am trying to get Column "V" to show the Bid Amount in Column "R" only if the date in Column "O" is withing this week Sunday through Saturday and blank if not within this week?
=IFERROR(IF(WEEKNUM(TODAY())-WEEKNUM(O2)>1,"Old",IF(WEEKNUM(TODAY())-WEEKNUM(O2)>0,"Old",R2)),"")
I need it to only show SUNDAY through SATURDAY of CURRENT WEEK