Confusing Date Placement for an excel worksheet I use for a video game.

Kate_

New Member
Joined
Feb 4, 2025
Messages
2
Office Version
  1. Prefer Not To Say
Platform
  1. Web
Im in the process of trying to make an excel worksheet for a video game called "Vintage Story" In the game, there are some complex farming dates and it gets way too confusing to keep track of.
So I turned to using excel that I use for alot of games to help.

To the point:
I need excel to search a column for a specific word such as "Planting Turnip" Then check another cell that says how long that turnip plants for and go -Down- from that cell that many times and then type "Harvest Turnip"

For this refrence: Turnips take 12 days to plant and harvest.

TurnipN12
In the game there are 12 days to one month.


I need it to look like this:
March1Planting TurnipTurnipN12
March2CabbageN18
March3SpeltN24
March4RyeN24
March5AmaranthN24
March6PinappleN72
March7SunflowerN22
March8Bell PepperN26
March9
March10
March11
March12Harvest Turnip
April1
Can someone help me figuring out how to start with something like this?
 
Im in the process of trying to make an excel worksheet for a video game called "Vintage Story" In the game, there are some complex farming dates and it gets way too confusing to keep track of.
So I turned to using excel that I use for alot of games to help.

To the point:
I need excel to search a column for a specific word such as "Planting Turnip" Then check another cell that says how long that turnip plants for and go -Down- from that cell that many times and then type "Harvest Turnip"

For this refrence: Turnips take 12 days to plant and harvest.


TurnipN12
In the game there are 12 days to one month.


I need it to look like this:

March1Planting TurnipTurnipN12
March2CabbageN18
March3SpeltN24
March4RyeN24
March5AmaranthN24
March6PinappleN72
March7SunflowerN22
March8Bell PepperN26
March9
March10
March11
March12Harvest Turnip
April1
Can someone help me figuring out how to start with something like this?
Didnt copy and paste very easily with the table,
March1Planting Turnip-TurnipN12
March2--CabbageN18
March3--SpeltN24
March4--RyeN24
March5--AmaranthN24
March6--PinappleN72
March7--SunflowerN22
March8--Bell PepperN26
March9--
March10--
March11--
March12Harvest Turnip-
April1--
 
Upvote 0

Forum statistics

Threads
1,226,771
Messages
6,192,919
Members
453,767
Latest member
922aloose

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top