I have Excel sheet with data of person multiple logins in a particular day i wish to seperate only one login per day in different row

Employee has logged in to the system 10 times on 02/07/23, 5 times in 03/07/2023, then 7 times next day and so on, I want to refine the data to get employee one login per day so that I can know on which date the employee was on leave.

As the employee has logged in multiple times in to the system each day it's difficult to find out on which day he was on leave as there is so much data, so I just want to refine his logins to one per day.

You can get the missing dates in a column of dates as follows:

Givens:

• Column of login dates is Column A.
• Date range of interest is 3/1/2023 to 3/30/2023

First we need a list of all days in the month of March:

DATE(2023, 3, 1) + SEQUENCE(31,,0)

We will want to match that against the column of login dates and return the date if it is not matched. We can use the LET function to add clarity:

 LET(  DT
     , DATE(2023, 3, 1) + SEQUENCE(31,,0)
     , IF( ISERROR( MATCH( DT, $A:$A, 0 ) ), DT, "--" )
    )

Finally, we can wrap the whole thing in a UNIQUE and SORT to clean the output:

SORT( UNIQUE( LET(  DT
                   , DATE(2023, 3, 1) + SEQUENCE( 31,,0)
                   , IF( ISERROR( MATCH( DT, $A:$A, 0 ) ), DT, "--" )
                 )
            )
    )

Sample Input:

Yields: