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
Nidhi CloudNidhi Cloud 

How to create Formula field which displays last date of month when opportunity is closed won. Please help!

Best Answer chosen by Nidhi Cloud
CharuDuttCharuDutt
Hii Nidhi Cloud
Try Below Formula 
Formula Field Type Date 
IF( ISPICKVAL( StageName, 'Closed Won') , DATE(
YEAR(TODAY()),
MONTH(TODAY()),
CASE( MONTH(TODAY()),
1, 31,
2, IF( MOD( YEAR(TODAY()), 4) = 0, 29, 28),
3, 31,
4, 30,
5, 31,
6, 30,
7, 31,
8, 31,
9, 30,
10, 31,
11, 30,
12, 31,
0
)
), null)
Please Mark It As Best Answer If It Helps
Thank You!
 

All Answers

CharuDuttCharuDutt
Hii Nidhi Cloud
Try Below Formula 
Formula Field Type Date 
IF( ISPICKVAL( StageName, 'Closed Won') , DATE(
YEAR(TODAY()),
MONTH(TODAY()),
CASE( MONTH(TODAY()),
1, 31,
2, IF( MOD( YEAR(TODAY()), 4) = 0, 29, 28),
3, 31,
4, 30,
5, 31,
6, 30,
7, 31,
8, 31,
9, 30,
10, 31,
11, 30,
12, 31,
0
)
), null)
Please Mark It As Best Answer If It Helps
Thank You!
 
This was selected as the best answer
Nidhi CloudNidhi Cloud
Hi Charu Dutt,
Thanks alot it worked perfectly!!