1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Auto Fill date based on the first item?

Hi I've been tasked with making a fillable excel form for employees of a small business to fill out their own timesheets. We used to use a pre-made one but it's no longer fit for us.

In the premade one, it didn't provide any functions for me to work backwards from, so I'm asking here.

Something the form could do is, by entering one date in one cell, the rest of the month would automatically fill itself out. (IE if you filled in that the first week began on january 01st, the rest of the form's mondays, tuesdays, etcs would also have the correct date attatched)

Any advice on how to automate this?

submitted by /u/Ok_Wrongdoer_1966
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#rows.com
#business intelligence tools
#financial modeling with spreadsheets
#cloud-based spreadsheet applications
#auto fill
#excel form
#fillable
#timesheets
#small business
#date
#automation
#cell
#premade
#functions
#correct date
#fill itself out