ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Help - If statement will not work (https://www.excelbanter.com/excel-worksheet-functions/268456-help-if-statement-will-not-work.html)

Randy Mis
Help - If statement will not work
 
=IF($E3TODAY(),$E3-TODAY()&" Until Due",IF($E3<TODAY(),TODAY()-$E3&" Days Overdue",IF($E3=TODAY(),$E3=TODAY()& "Due Today")))

This formula should populate a box with the # of days until an item is due, the # of day the item is over due and if due today the box should read Due Today.

It works for Items # of Days Overdue and # of Day Unti Due, but I can not get the box to read Due Today.

wickedchew
Quote:
Originally Posted by Randy Mis (Post 962504)
=IF($E3TODAY(),$E3-TODAY()&" Until Due",IF($E3<TODAY(),TODAY()-$E3&" Days Overdue",IF($E3=TODAY(),$E3=TODAY()& "Due Today")))

This formula should populate a box with the # of days until an item is due, the # of day the item is over due and if due today the box should read Due Today.

It works for Items # of Days Overdue and # of Day Unti Due, but I can not get the box to read Due Today.
=IF($E3TODAY(),$E3-TODAY()&" Until Due",IF($E3<TODAY(),TODAY()-$E3&" Days Overdue",IF($E3=TODAY(),TODAY()& "Due Today")))


All times are GMT +1. The time now is 03:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com