Forum Discussion
Reminder setting issue
Unfortunately an image alone doesn't really help much in the diagnosis.
A guess, however, based on your verbal description: it sounds as if some of the dates in column D may actually contain text rather than numbers formatted as dates. They would look alike to the human eye, but Excel treats them differently.
If that's not it, may I suggest you post a copy of the actual workbook, just blocking out or altering any confidential or private information.
Dear Mathetes,
attached is a copy of the workbook. What I am trying to do is if any of the cells D6-K6 or all of them have the number 1 inside, then in cell AO to make it automatically either to show number 15 or to sum the date in D2 + 15.
I am not sure if that helps. Thannks for your help anyway.
Well, I'm sorry to be difficult (or dense, whichever it is), but a blank spreadsheet isn't a lot more helpful than an image.
I've entered a formula in cell AO6, but it's a feeble attempt to read your mind on what you want.
What would be helpful is if you'd
- place some representative data in some of the cells...it's not clear, for example, if you'll just be entering the number 1 in those cells under the days of the month
- If there are other numbers, what does each of them represent?
- What does the "15" represent? Instead of hard-coding, it would be better if we used a named variable. And that goes for the other numbers as well, if there is a "code" or meaning to them.
- place some desired answers (with explanation) in the columns AO and others associated OR, even better, a formula or two that you've tried, showing what it does produce and contrasting that with what it should and why. Add text boxes or a description of what you're trying to do.
Otherwise, you're kind of asking the folks here to read your mind as to the underlying thought processes. Your preliminary description is OK, but in person, I (and I suspect others) would be still asking a lot of questions. Anticipate those questions..
Dear Mathetes,
to begin with, thank you for your time and efforts.
I have attached a spreadsheet trying to describe what is the situation and what I need to do.
I hope it helps
