LinkBack URL
About LinkBacks
Hi,
LOOK UP NEXT DUE DATE USING LAST DONE DATE AS REFERENCE ?
SO THIS SHOULD TELL ME NEXT DUE DATE IS 05/08/2014 IN "E5". BASED ON LAST DONE DATE "D5" AND YES IS SELECTED "M5".
I HAVE TRIED SOME BUT HAD TO DELETE THEM
ANY HELP PLEASE
CHEERS
IAIN
Hi,
LOOK UP NEXT DUE DATE USING LAST DONE DATE AS REFERENCE ?
SO THIS SHOULD TELL ME NEXT DUE DATE IS 05/08/2014 IN "E5". BASED ON LAST DONE DATE "D5" AND YES IS SELECTED "M5".
I HAVE TRIED SOME BUT HAD TO DELETE THEM
ANY HELP PLEASE
CHEERS
IAIN
as you have frequency in there
can you not just add weeks frequency onto it?
put in e5
Formula:
Please Login or Register to view this content.
FYI your example d5 you put 15-7-15 which does not exist in your header
i think you meant 15-7-14?
also all caps...sounds like your screaming
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
ok i notice you have 12W in which case
Formula:Please Login or Register to view this content.
and also OL?
what is OL?
anyway this should solve OL as well
Formula:Please Login or Register to view this content.
Last edited by humdingaling; 05-28-2015 at 12:08 AM.
Thank You,
So I will stop screaming now? So "W" is for weeks, "Y" is for years and "OL" is off line.
Works well except when you pick 1Y or 2Y is does not pick up that it is 1 year away on date?
This is so I can add in another row to replace my tank every 2 years. It is for my aquaponics set up that I have started 10 months ago.
Thanks Iain
E5=if(right(g5,1)="w",d5+max(1,iferror(left(g5,len(g5)-1)+0,0))*if(right(g5,1)="w",7,if(right(g5,1)="m",1,if(right(g5,1)="y",12))),if(or(right(g5,1)="m",right(g5,1)="y"),edate(d5,max(1,iferror(left(g5,len(g5)-1)+0,0))*if(right(g5,1)="w",7,if(right(g5,1)="m",1,if(right(g5,1)="y",12)))),""))copy towards down
Please Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Formula:Please Login or Register to view this content.
OL = blank
W = x7
not OL or W...must be Y unless you add another DV option
Y = x364
tested to be the same as your formula for "YES" which is 52*7= 364
Last edited by humdingaling; 05-28-2015 at 03:02 AM.
Made some further amendments to take into account if last done is blank in case that is your next question
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks