Hello,
Could someone please help me?
I have:
A1 - Created date.. 21.08.19
B1 - Feedback date.. 23.08.2019
I need formula to calculate: after how many days of ''Created'' came ''Feedback''?
C1 - Feedback 1st day (If yes 1, otherwise 0) - this should include the current date of creation and the next day.. (21.08.2019 and 22.08.19)
D1 - Feedback 2nd day (If yes 1, otherwise 0) - this should include the day after creation (23.08.2019).
I will appreciate your help, thank you
Last edited by EHH; 08-30-2019 at 03:26 AM.
I don't follow this... Is is as simple as =B1-A1 where feedback date is in B1 and created in A1???
If not, post a sample sheet with SEVERAL manually calculated examples.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
No, that would be too easy to mee.
It goes like this.
If feedback came 1 day after the created day - PUT 1, say TRUE.. otherwise 0.
If feedback came on the 2nd day after the created day - PUT 1, say TRUE.. otherwise 0.
Maybe I cannot explain it good enough because I'm a begginer in excel.
I don't need to cound how many days are in between!!
I need to say TRUE or FALSE:
In this case it would be:
Feedback 1st day: 0 (FALSE)
Feedback 2nd day: 1 (TRUE)
I need this formula to show true or false there..
Only one sample and no sheet as requested.... So, another guess:
=(B4-A4)>0
Here please, find attached the document.
Quote 1st day
Quote 2nd day
Quote 3rd day
Quote 4th day
Quote 5th day
Feedback 1st day
Feedback 2nd day
Feedback 3rd day
Feedback 4th day
Feedback 5th day
I only need to say TRUE or FALSE.
So, what you want is more complicated than your original description!! However, we now have 1 created date, several quote dates and several feedback dates. What do you expect to see? Where do you expect to see it?
Please add manually calculated results to your sheet.
I am sorry I cannot good explain.
This is it basically, If you can see the comments on the fields..
CREATED DATE - QUOTES..
If Quote came on the second day after Created Date say:
Quote 1st day FALSE
Quote 2nd day TRUE
QUOTES - FEEDBACK...
If Feedback came on the first day after the Quote say:
Feedback 1st day TRUE
Feedback 2nd day FALSE
Hope I'm clear enough, and thank you for helping me out
Last edited by EHH; 08-30-2019 at 03:55 AM.
Still not there, yet, I think. the formulae have been changed to extract dates, rather than text that look like dates.
Please check the expected results, as I am still a tad confused!!
Let me give this another try:
I have:
A1 - 21.08.19 (this is Created Date)
B1 - 23.08.2019 (this is Date when Quote came)
Now, I need to show here TRUE or FALSE:
C1 - Quote came after 1 day of Created Date (if Yes 1, if Not or Empty 0)
D1 - Quote came after 2 days of Created Date (if Yes 1, if Not or Empty 0)
(In this case, C1 should appear 0, and D1 should appear 1.
Please amned my sheet. Overtype ALL the True/false values with YOUR expected results. Please stop switching from TRUE/Yes/1 and FALSE/No/0. That does NOT help.
Ok here we go,
The idea is,
With this formula 'Quote 1st day, Quote 2nd day and Quote 3rd day, they are all same.
If you check E2, F2, G2 - they are All showing TRUE.
Only E2 should say TRUE, because Quote came on the first day of Created Date. (same date).
and next,
E3, F3, G3 - they are all showing FALSE.
In this case we have, 21.08.19 (created date) and 23.08.2019 (Date of the Quote), which says - quote came after 2 days of created date.
So, F3 should say TRUE..
One more touch and you're there
Once again, you have changed the quote formula back to one that produces text. in Excel dates are numbers (the no. of days from 0th January 1900) that are formatted to look like dates. Formulae extracting dates need to extract a number and then format it to look like a date.
Created 21/8/2019.
Quote on 21/8/2018 day 1 = TRUE, all the rest false
Quote on 22/8/2019, day 2 = TRUE, all the rest false
Quote on 23/8/2019, day 3 = TRUE, all the rest false
I that is the logic, why should F3 (as opposed to G3) be false?????
=IF($C2="","",$C2=$D2-(COLUMNS($D:D)-1))
in E2, copied across and down.
I can work with this now.
Thank you very much for your help
And sorry I cannot good describe, bcuz I'm far from it :/
Just started excel trainings and stuff.
Thanks mate
Woo hoo!!! You're welcome...
Getting a solution quickly is all about defining your problem accurately & completely. We got there!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks