Problem in Weekly recurring schedule using excel formula
Dears,
Please, I did a Weekly recurring schedule using Excel formula. The formula is good and applied for all intervals but it does not consider the "Start Date". I need to update this formula to consider any change in the Start date, so it does the required shift in the recurring schedule.
Formula problem.JPG
sample demo 2.xlsx
Thanks
Hello HemaEXCEL and Welcome to Excel Forum.
Would it be correct to assume that 1.1 should be in cells E5, G5 etc.?
Would it be correct to assume that 0.4 should be in cells F7, J7 etc.?
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Is this what you're looking for? Formula in E5, and drag to copy. You just missed an INT() in the middle
Formula:
Please Login or Register to view this content.
Last edited by Seabottom; 09-30-2023 at 02:58 PM.
Thanks Seabottom, But this won't to do, I want to apply this value in cells based on Interval and Start date.
Thanks, JeteMc for your reply, But this is an example. the real sheet has huge data. So this value changes pass on the input.
It is not clear. Is it possible to explain with example and showing the expected result in the file..
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
"Thanks, JeteMc for your reply, But this is an example. the real sheet has huge data. So this value changes pass on the input."
I was not proposing a solution, but rather asking questions.
That said perhaps the following in cells E5 down and over will do what you want: =IF(LEN($D5)=0,"",IF(OR($D5=E$4,MOD(E$1-$D5,$B5*7)=0),$C5,""))
Let us know if you have any questions.
Edited formula: =IF(LEN($D5)=0,"",IF(AND($D5<=E$4,MOD(E$1-$D5,$B5*7)=0),$C5,""))
Last edited by JeteMc; 10-02-2023 at 03:04 PM. Reason: Added edit
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks