[Solved] Need help with IFS function in formula's. See Notes tab for my questions and comments.

General Excel Questions & Answers

2 Posts

2 Users

1 Reactions

376 Views

RSS

Harry Moore

(@eroomdh)

Posts: 1

New Member

Topic starter

Posted : 11/12/2025 3:14 am

Alan Sidman

(@alansidman)

Posts: 266

Member Moderator

=IF(Table3[@[Due Date]]="NA","",IF(Table3[@[Due Date]]<TODAY(),"Overdue",IF(Table3[@[Due Date]]>TODAY()+30,"Not Due","Due Soon")))

Posted : 11/12/2025 4:27 am

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed