RSS Amplifier

Recent Questions - Web Applications Stack Exchange · Nov 3, 2022

Creating a rolling date formula to automate spreadsheet

0
Sign in to vote or save

This page did not load. You can still read it on the original site — the toolbar below keeps your place in the directory.

I'm not very experienced with google sheets formulas, and I'm attempting to create a rolling year formula for a scholarship spreadsheet. All I really need it to do (if it's even possible) is to automatically update the year once the date listed in a column has passed. For example, if the date is 2/1/2022 and that date has passed it just needs to update to 2/1/2023. EDATE has seemed like the most…

I'm not very experienced with google sheets formulas, and I'm attempting to create a rolling year formula for a scholarship spreadsheet. All I really need it to do (if it's even possible) is to automatically update the year once the date listed in a column has passed. For example, if the date is 2/1/2022 and that date has passed it just needs to update to 2/1/2023. EDATE has seemed like the most effective solution for this, but it would have to be manually done once a year and I will no longer be working in this position by next year and won't be here to update it myself. So I am attempting to automate the sheet so I won't have to leave instructions on just how to update the dates. This is for ease of use and so that the sheets can be continued to be used without having to manually update 100s of dates every year.

Read on webapps.stackexchange.com

Comments

Nothing yet. Say the first thing.

    Sign in to join the conversation.