The following format is used for this formula: ![]() Use the DAYS function to accomplish this. Subtract a specific number of days from the date field.įor example, to subtract five days from a date:ĭATE(YEAR(DAYS(field("Due date"), 5)), MONTH(DAYS(field("Due date"), 5)), DAY(DAYS(field("Due date"), 5)))Ĭalculate the difference between two dates. Use the DATE function and apply basic mathematical expressions for YEAR(), MONTH(), OR DAY().įor example, to add seven days to a date:ĭATE(YEAR(field("Due date")),MONTH(field("Due date")),DAY(field("Due date"))+7) You can use advanced formulas to add or subtract days, show percent signs, round decimal places, and more! You can use advanced formulas to add or subtract days, show percent signs, round decimal places, and more! Desired outcomeĪdd a specific number of days to the date field.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |