I'm trying to get the answer from a cell that changes to the next cell down daily and have it copied to a fixed cell. For example the answer always goes into cell E3. However, the cell the answer is in would be E50 one day then E51, E52, E53 and so on, changing every 24 hours.
I want the contents of cell E that corresponds to today's date to show in E3. Ive used a temp solution but have to manually increment it every day.
Sheet attached
TIA Glen
[Solved] Cell to showing different cell contents every day
-
Midnight Man
- Posts: 1
- Joined: Tue May 22, 2018 2:46 pm
[Solved] Cell to showing different cell contents every day
- Attachments
-
- Rent Account.ods
- (33.32 KiB) Downloaded 51 times
Last edited by Midnight Man on Wed May 23, 2018 7:31 pm, edited 2 times in total.
Libreoffice Version: 6.0.4.2
Manjaro Linux
Manjaro Linux
Re: Get 1 cell to show different cell contents every day
Try this formula in E3
Code: Select all
=OFFSET(E6;TODAY() - DATE(2018;4;1);0)OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.