Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
PFangPFang 

Date formula for client reports

Hi guys,

 

Great day!

 

I need something that would compute for a client's report due date. The computation should be start date + 1 month - 4 days.  Help on this would be appreciated!

 

DATE( YEAR(today()),


IF ( MONTH(Start_Date__c) = 1, 2,
IF ( MONTH(Start_Date__c) = 12, 1,
MONTH(Start_Date__c) + 1)),


IF ( DAY(Start_Date__c) = 4,

CASE( MONTH(Start_Date__c),
1, 28,
3, 30,
12, 31
,null),

IF ( DAY(Start_Date__c) = 3,

CASE( MONTH(Start_Date__c),
1, 27,
3, 29,
12, 30
,null),

IF ( DAY(Start_Date__c) = 2,

CASE( MONTH(Start_Date__c),
1, 26,
3, 28,
12, 29
,null),

IF ( DAY(Start_Date__c) = 1,

CASE( MONTH(Start_Date__c),
1, 25,
3, 27,
12, 28
,null)

,DAY(Start_Date__c) -4 ))))



)

 Regards,

 

Pfang

Carolina Ruiz MedinaCarolina Ruiz Medina
Hi PFan,
The formula you posted seems to work, might be it could be simplify but it works, do you still need help? .. I guess no ? :) 
Have a nice day!