I want to find date of joining
Solved/Closed
Ansh_5770
Posts
2
Registration date
Sunday September 19, 2021
Status
Member
Last seen
September 19, 2021
-
Updated on Sep 23, 2021 at 01:39 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Sep 20, 2021 at 11:22 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Sep 20, 2021 at 11:22 AM
Related:
- I want to find date of joining
- Timed out while joining wifi ✓ - Network Forum
- How to listen to a snapchat call without joining - Guide
- Connection timing out when network is just fine ✓ - WiFi Forum
- Mw2 not joining game ✓ - Video Games Forum
- How to change background in ms teams before joining meeting - Guide
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
544
Updated on Sep 20, 2021 at 11:58 AM
Updated on Sep 20, 2021 at 11:58 AM
Hi Ansh,
'i have a attandance sheet like this'
It would be helpful to show what your attandance sheet looks like.
What is entered in the cell, you want to determine the date of joining from?
Best regards,
Trowa
EDIT: Ok, I just saw the screenshot you sent me in a pm. So you use column F to AJ for each of the days of the month. The rows are used for names. The entire table is filled with letters A, P, W/O and PH.
No idea what the letters stand for, but that doesn't matter much. In the formula below we are looking for the first occurance of the letter A:
=DATE(YEAR($F$12),MONTH($F$12),DAY(MATCH("A",F13:AJ13,0)))
For the formula to work, the date row needs to contain full dates. So enter 1/10/2021 and then give it a custom format (cell properties) of "d", so the cells will look the same as they are now.
Let us know if something is unclear.
Best regards,
Trowa
'i have a attandance sheet like this'
It would be helpful to show what your attandance sheet looks like.
What is entered in the cell, you want to determine the date of joining from?
Best regards,
Trowa
EDIT: Ok, I just saw the screenshot you sent me in a pm. So you use column F to AJ for each of the days of the month. The rows are used for names. The entire table is filled with letters A, P, W/O and PH.
No idea what the letters stand for, but that doesn't matter much. In the formula below we are looking for the first occurance of the letter A:
=DATE(YEAR($F$12),MONTH($F$12),DAY(MATCH("A",F13:AJ13,0)))
For the formula to work, the date row needs to contain full dates. So enter 1/10/2021 and then give it a custom format (cell properties) of "d", so the cells will look the same as they are now.
Let us know if something is unclear.
Best regards,
Trowa