Forum Discussion
FORMAT IF STATEMENT TO "DDD DD MM YY"
Guys, is there a way to format the below to show the date format as DDD DD MM YY? Thanks Next 5 Days = IF(Query2[DateIn]=Today(), Today(), IF(Query2[DateIn]=Today()+1, Today()+1, IF(Query2[Date...
Hi Anonymous
Check below formula.
Next 5 Days = FORMAT ( IF(Query2[DateIn]=Today(), Today(), IF(Query2[DateIn]=Today()+1, Today()+1, IF(Query2[DateIn]=Today()+2, Today()+2, IF(Query2[DateIn]=Today()+3, Today()+3, IF(Query2[DateIn]=Today()+4, Today()+4,IF(Query2[DateIn]=Today()+5, Today()+5,IF(Query2[DateIn]=Today()+6, Today()+6, BLANK()))))))), "DDD DD MM YY" )Regards,
Thanks, so i have creatred a new column to format ie DAYS FORMATED = FORMAT(Query2[Next 5 Days], "DDD DD MMM, YY") but i see above the format code is actually built into the Next 5 days formula. How do i do that? Many thanks for your help
Next 5 Days = IF(Query2[DateIn]=Today(), Today(), IF(Query2[DateIn]=Today()+1, Today()+1, IF(Query2[DateIn]=Today()+2, Today()+2, IF(Query2[DateIn]=Today()+3, Today()+3, IF(Query2[DateIn]=Today()+4, Today()+4,IF(Query2[DateIn]=Today()+5, Today()+5,IF(Query2[DateIn]=Today()+6, Today()+6, BLANK())))))))
v-cherch-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous
Check below formula.
Next 5 Days =
FORMAT (
IF(Query2[DateIn]=Today(), Today(), IF(Query2[DateIn]=Today()+1, Today()+1, IF(Query2[DateIn]=Today()+2, Today()+2, IF(Query2[DateIn]=Today()+3, Today()+3, IF(Query2[DateIn]=Today()+4, Today()+4,IF(Query2[DateIn]=Today()+5, Today()+5,IF(Query2[DateIn]=Today()+6, Today()+6, BLANK()))))))),
"DDD DD MM YY"
)
Regards,