function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Jean-Sebastien DoraisJean-Sebastien Dorais 

Date Manipulation Based on TODAY()

All,

I'm stumped and reaching out to the community.

I'm trying to create a formula that will display a date based on TODAY().  Here are the criterias:
  • If TODAY() is between January 1 and April 30, set the date to TODAY() + 15 days of the CURRENT year
  • If TODAY() is between May 1 and December 31, set the date to February 1 of NEXT year
Any pointers are appreciated!
Best Answer chosen by Jean-Sebastien Dorais
Gabriel C FerreiraGabriel C Ferreira
Hi Jean,

Try that formula: 
IF (MONTH(TODAY()) > 4,
    DATE(YEAR(TODAY()) + 1, 2, 1),
    TODAY() + 15
)
If the month is "bigger" then April, set the date to February 1 of next year. In other case, add 15 days to Today().

If it helps you, please mark as the best response.

Best regards.