Forum Discussion
Determine training week # based on start date
Hello everyone,
I am working on a project, and I am stumped. Attached is an example workbook (please do not change the columns as they are the same as the original project).
Simply put, I have a start date and I need to know what week of training they are in up to 8 weeks. If they are not in training, leave it blank (no zero's). The week starts on a Monday
Thank you for your help.
1 Reply
catherine9910 If a date falls in more than 1 week, then what result do you expect? Can you show your desired output in attach file manually so that we can make it by formula?
