Hello, I have attached my file, and I would like to add a formula in column c that would tell me in how many days the x is in, for each line.
Thank you very much for your help.
Hello, I have attached my file, and I would like to add a formula in column c that would tell me in how many days the x is in, for each line.
Thank you very much for your help.
Hi and welcome to the forum.
You don't say where the xs are although I assume you are manually entering on each row. But what do you mean by 'In how many days'? Is that starting from 1st Jan, pr from some other date like say today?
If the former then perhaps in C8
Formula:Please Login or Register to view this content.
But why not explain exactly what you're trying to achieve since it's somewhat unusual to see columns used for so many dates , i.e. out to column AGL. Normally when so many dated are involved it's better to have them listed vertically but if you tell us the final goal then there may well be a more efficient way of getting what you want. For instance given two dates, say 1st Jan and the date on which you currently record an x it's much simpler to subtract one date from the other.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
You not confirm about where to enter "X".
I assume you entered "X" in row 8
formula in "C7"Formula:Please Login or Register to view this content.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Hello, I would like to calculate as of today's date, I added todays date in the file, its attached again.
Sorry for the late reply, I was away.
Thank you
Pascale
In C8, try
=MIN(IF((D8:ZS8="x")*(D$6:ZS$6>=TODAY()),D$6:ZS$6))-TODAY() Ctrl Shift Enter
hello, Thna k you very much, this formula worked, now can i have it leaft at zero if there are no x in the row?
Pascale
Sure, change the formula to this:
=IF(COUNTIF(D8:ZS8,"x"),MIN(IF((D8:ZS8="x")*(D$6:ZS$6>=TODAY()),D$6:ZS$6))-TODAY(),0) Ctrl Shift Enter
If that solved your question, please mark this thread as SOLVED.
Thnak you very much for your help.this is resolved. But I don't know where to put this post into the resolved status.
Great! Happy to help.
To mark a thread as SOLVED, follow these steps:
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks