I want to find date of joining

Report
Posts
2
Registration date
Sunday September 19, 2021
Status
Member
Last seen
September 19, 2021
-
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
-
Hello everyone i have a attandance sheet like this i want to find date of joining by formula.
Mean on which date from 1 to 31 he started to work i want that date for date of joining .
if he started to work date 6 so his date of joining should be 06/10/2021

1 reply

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
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


1
Thank you

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM 2821 users have said thank you to us this month