Show Msg If Range date value is greater then 30 from today's date

hi,
i have a data in sheets("entry").range("p3")

to i want to compare this date to Today's date

if difference found more then 31st days then appear a msgbox

thank you

Hi HarroonSid- put this in the ThisWorkbook Module of your workbook:

Please Login or Register  to view this content.

NOTE: This code assumes P3 contains a numerical Date, not text.

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

Thank you leelnich
its working very well