IF function with dates
Solved/Closed
ayudameexcel
-
Aug 17, 2020 at 10:40 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Aug 20, 2020 at 11:47 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Aug 20, 2020 at 11:47 AM
Related:
- Excel if statement with dates
- Fenix internet on bank statement - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Kernel for excel repair - Download - Backup and recovery
- Apple iphone 13 release dates - Guide
- Vat calculation excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
Aug 20, 2020 at 11:47 AM
Aug 20, 2020 at 11:47 AM
Hi Ayudame,
Give the following formula a try:
=IF(AND(ISERROR(TODAY()+A2)=FALSE,B2="no show status"),"yes","")
Best regards,
Trowa
Give the following formula a try:
=IF(AND(ISERROR(TODAY()+A2)=FALSE,B2="no show status"),"yes","")
Best regards,
Trowa