How to check user password expiry date in Microsoft 365?
+
Password expiry date in Microsoft 365 is not directly accessible since it depends on the number of days configured in the domain password policy. Also, the countdown to password expiration starts from the last time a user changed their password. Each user may have a different expiration date based on their individual password change history.
Therefore, to check the password expiration date in Office 365, manual calculation is required by comparing the days in the password expiration policy with the individual user's last password change date.
You can get password validity period of your organization’s password policy using the below PowerShell cmdlet.
Get-MgDomain -DomainID "<Domain name>" | select -Property Id, PasswordValidityPeriodInDays
You can find last password changed date in Office 365 using the Graph PowerShell cmdlet below.
Get-MgUser -All -Property DisplayName,lastPasswordChangeDateTime | select DisplayName,lastPasswordChangeDateTime
Additionally, you can check the leaked credential report in Microsoft Entra ID to validate the current security measures of user account passwords. It also helps you to identify and address any potential vulnerabilities or compromised credentials promptly.
Using the 'Users with Password Expiry' report, you can effortlessly find the accurate password expiration date of Microsoft 365 users without any manual calculation.
This report includes other necessary details such as the user’s last password changed date, password expiry status, etc.
PRO TIP: You can sort the report data in ascending or descending order by simply clicking the column heading. Here, you can click on 'Password Expiry Date' to arrange the data in ascending order to identify the users with earliest password expiration date.