Hi All,
I would like advice and help with a Multiple IF question as complete novice with Formulae and have read so much on IF, AND, OR am getting confused.
What I would like help on is the following:
There is a Date in Cell A1.
Cell B1 would show the following "text" based on the condition below:
1. If the Date is between 0-91 days from the date in A1, show "0-13 Weeks"
2. If the Date is between 92-140 days from the date in A1 show "14-20 Weeks"
3. If the Date is between 141-210 days from the date in A1 show "21-30Weeks"
There are 2 additional conditions but I will add (and learn) them later.
Can anyone help with the above.
Many Thanks
Craig
Bookmarks