My weeks end on Friday.
I need a formula that will look at dates in row 6 and based on that day insert $10,000 if that date is the end date for week 3
If date is not 3rd week cell needs to be 0.
For examples:
05/04 last day of first week insert 0
05/11 last day of 2nd week insert 0
05/18 last day of 3rd week insert $10,000
Thank you
Bookmarks