Home

How to auto add weekdays for tracking hours

%3CLINGO-SUB%20id%3D%22lingo-sub-863272%22%20slang%3D%22en-US%22%3EHow%20to%20auto%20add%20weekdays%20for%20tracking%20hours%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-863272%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20I%20have%20an%20excel%20sheet%20to%20represent%20a%20week%2C%20which%20I%20will%20then%20fill%20in%20with%20data%20(hours%20worked%20in%20the%20different%20categories%20of%20a%20project).%20Since%20each%20sheet%20is%20dated%20to%20that%20week%2C%20and%20theres%20a%20column%20for%20each%20day%2C%20is%20there%20a%20way%20to%20make%20those%20days%20automatically%20add%20their%20day%20of%20the%20month%3F%3C%2FP%3E%3CP%3Esee%20attached%20example%20(on%20second%20sheet)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20any%20suggestions%20on%20improvements%20I%20could%20make%20to%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-863272%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
mbartolucci
Occasional Contributor

So I have an excel sheet to represent a week, which I will then fill in with data (hours worked in the different categories of a project). Since each sheet is dated to that week, and theres a column for each day, is there a way to make those days automatically add their day of the month?

see attached example (on second sheet)

 

Also, any suggestions on improvements I could make to this?

 

Thanks for the help!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies