Change Dates Depending on certain cell

[1541sean]

Hi I am making a food order form where my first delivery is Monday C9 Date C11. my next delivery is C21 this changes with dropdown and date in C23 this continues Down sheet multiple times i would like the DATES to update using C11 as start date so c23 will match c21 and so on down sheet

Any help would be grateful
Regards Sean.

[etaf]

yiou have a version 2016-365 - lots of difference in functions , which version is this to work in

Note: Images are difficult to see , and also requires that I input all the data myself, which means I may make an error, which is very time consuming, and from my point of view less likely to get a response, if a complicated spreadsheet.

A sample sheet would help here, and possibly will enable a quicker and more accurate solution for you.


The forum does allow for spreadsheets to be uploaded direct to the forum -

Please see the Yellow Banner at the top of the page explaining how to attach a sample spreadsheet

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

Here are the instructions, found at the top of the page again

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

[1541sean]

Hi i need it to work in 2016 thanks for help

[etaf]

ok, not following exactly

instead of putting the days of week in - just put the date and format as DDDD
that will show the day

you enter
9th oct 9/10/23 in C11
then you want the next tuesday in C23 - why is it showing 11/7/23 ???

and thursday in c34

dont follow the dates you have entered

C23 = 11/7/23 - why thats in the past
C34 = 13/7/23 - - why thats in the past


if you put 9/10/23 into cell c11
in C9 you could put = C11 and format as DDDD

then in C23
C11+1
will add a day
and then in C21 put
=C23 + 1 and format as DDDD

etc


but you have data validation in place and choosing day

so

i would like the DATES to update using C11 as start date

[1541sean]

Hi I have data validation because delivery different days on different weeks
The dares that are there I was testing formula but can't get to work in all date fields.
Thanks again for helping.

[etaf]

ok, still not following - can you explain what you would like ... in more detail

Monday C9 Date C11. my next delivery is C21 this changes with dropdown and date in C23 this continues Down sheet multiple times i would like the DATES to update using C11 as start date so c23 will match c21 and so on down sheet

do you want to change the day or the date - you say
update C11 - which is a date
as i explained , maybe not well enough, you can get the day of a date simply by formatting as DDDD - no needed for the dropdown - if you want to change the date in C11 as mentioned

so then what date(s) do you want in the other cells ? to autimatically fill

can you give and example - if you enter

9/10/23 into cell C11 as requested
then what dates do you want in the other cells ?

[1541sean]

I just want to change the dates in cells C23,C34,C46 etc. when i change Day I want date to match the day. My start date will always be in C11 and it runs for a 4 week cycle with 1 to 4 deliveries a week.
Hope I have explained correctly.
Thanks again.

[1541sean]

When i change days in cells C21,C32, etc.... i want dates to update in C23,C34 etc...

[GeoffW283]

Please try the following formula copied to C23 and C34. As best I understand I think this does what you want. Let us know.

Please Login or Register  to view this content.

[1541sean]

Hi thanks Geoff this worked great for first week for all days, is there a way to continue with dates to the next week as I run a 4-week cycle so once it goes past Saturday the Monday will be new week Monday 16th etc.....,
Thanks for your help.

[GeoffW283]

OK, try this in C23, C34 etc.

Please Login or Register  to view this content.

Attached is an update to your sample file extended to multiple weeks so that I could test. Let us know if this is what you are looking for.

[1541sean]

That is what I want Works great Thanks a million for all your Help this will save me a lot of time.
Thanks again.
Regards
Sean.

[GeoffW283]

Glad I could help. Thanks for the feedback and rep.