Forum Discussion
Solved
combining # of days and max formulas
Good morning, The spreadsheet tracks user tasks and the due date. I calculate the # of days using the DAYS function. The users in a separate column enter their completion date. For the due date col...
Using 365
= LET( days, DAYS(TODAY(), due), IF(days>0, days, 0) )or legacy systems
= IF( DAYS(TODAY(),due)>0, DAYS(TODAY(),due), 0)
Using 365
= LET(
days, DAYS(TODAY(), due),
IF(days>0, days, 0) )or legacy systems
= IF( DAYS(TODAY(),due)>0, DAYS(TODAY(),due), 0)
PeterBartholomew1 Thanks! The LET formula worked. I appreciate the help.