![]() |
#1
|
|||
|
|||
![]()
hi,
here is the situation. in "sample 1" file i need to change date and shift based on previous cell date. currently i managed to if A3 has date "DATE: 06/06/2023" then A20 will be "DATE: 06/06/2023" and if a3 has date "DATE: 06/06/2023" then A20 will be "DATE: 07/06/2023" and so on. it depends on "shift" as you can see i have to check it manually if there is production in both shifts of the day. if not i have to hide the entire row of page of that shift. if suddenly no production on a given date i change in manually then rest the dates goes following that date. shift formula and date formula is separated in sample 1 A20, A21 and so on. And shift cell A21 is simple, if A4 is "SHIFT : A" then A21 is "SHIFT : B" & A4 is "SHIFT : B" then A21 is "SHIFT : A". here is what i want to do- if A3 has date "DATE: 06/06/2023" & A4 is "SHIFT : A" then A20 will be "DATE: 06/06/2023" because A20 page is the same day but different shift. if A3 has date "DATE: 06/06/2023" & A4 is "SHIFT : B" then A20 will be "DATE: 07/06/2023" because its the next day another shift. now i want to combine this functions. so i tried the formula in "tried formula.docx". it gives "more than 64 level nesting" error while i paste it. please help me. i tried best i could to explain. please use the excel file to understand the situation more. Last edited by redirected_math; 06-06-2023 at 10:44 PM. Reason: simplified the attatchment (tried formula.docx) |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
INDEX and MATCH nesting with if | Peter Simpson | Excel Programming | 1 | 05-27-2019 06:53 AM |
![]() |
LearningMom | Mail Merge | 9 | 09-25-2017 01:44 PM |
![]() |
icor1031 | Word | 1 | 01-14-2016 09:24 PM |
Nesting and IF & AND statement | lynchbro | Excel | 4 | 04-16-2015 11:39 AM |
![]() |
Wyskers | Word | 1 | 11-13-2011 05:43 AM |