=IF(DATEDIF(B3;TODAY();”d”)>10;DATEDIF(TODAY();B3;”d”);”Less than 10days”),
I want to check whether the event date and today date difference is more than 10days,if so then print the days if not then print its less than 10 days in excel..
I wanted to get , say the event date is 24th April 2024 and TODAY() it should show the days 19days but its showing an error.
New contributor
Reshma Reghunandan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.