Forum Discussion
Solved
Display number based on number of days past cell date
I am working on trying to get an output for training classes. Based on the date they start training I want to automatically populate which week of training they are in. I am including weekends (or o...
=IF(TODAY()-N4<=7,1,IF(AND(TODAY()-N4>=7,TODAY()-N4<=13),2,IF(AND(TODAY()-N4>=14,TODAY()-N4<=21),3,IF(AND(TODAY()-N4>=22,TODAY()-N4<=29),4,"graduated"))))
I sent it a few minutes ago. Here it is again.
thank you for the advice. I think it mentioned something about including screenshot to assist, so that is why I put it.
That's only a comment for future. Recommendations are here Welcome to your Excel discussion space! - Microsoft Tech Community. File is on the first place, screenshot and other supporting content is always welcome.