Greetings Everyone,
I need some help in figuring out if what i want is possible. What I’m attempting is a time sheet where in Column A it will show the Day # based of Month, Year and Week Number. Example A4 = 06/02/21
Any Help or tips are appreciated!
Last edited by Mr.Trouble; 06-08-2021 at 02:54 PM. Reason: Solved
Not sure I've interpreted correctly, but I'll start with this. With the understanding the days listed are in week 1 of June 2021 this in A3 and filled down.
Not sure how many formulas you will be using I created some array constants to eliminate redundant calculations.Formula:
Please Login or Register to view this content.
And BTW in A4 I get 6/1/2021 which is correct.
in
Out
In
Out
Office
Last edited by FlameRetired; 06-07-2021 at 07:41 PM.
Dave
Or try:
Please Login or Register to view this content.
Define the name, the name is VV, enter the formula as below
=DATE($E$1,MATCH($B$1,XX,),1)
Define the name, the name is XX, enter the formula as below
={"January";"February";"March";"April";"May";"June";"July";"August";"September";"October";"November";"December"}
Define the name, the name is YY, enter the formula as below
={"Monday";"Tuesday";"Wednesday";"Thursday";"Friday";"Saturday";"Sunday"}
Define the name, the name is ZZ, enter the formula as below
=ROW(INDIRECT(VV&":"&DATE($E$1,MATCH($B$1,XX,),DAY(EOMONTH(VV,0)))))
Cell A3 Array formula , drag down
HTML Code:
Very clever.Originally Posted by Phuocam
Thank you Everyone for your help! with your help i was able to finish building my excel workbook. I've included a copy if you'd like to check it out.
Thank you for the added rep.Very clever.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks