Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
ShowAll Questionssorted byDate Posted
Manjeet Verma

# What is the formula of getting Current month first date and current month last date ?

What is the formula of getting Current month first date and current month last date ?
Best Answer chosen by Manjeet Verma
Malika Pathak 9

Hi Manjeet,

Find the below Solution

First day of the current month:

DATE(YEAR(TODAY()), MONTH(TODAY()),1)

Last day of the current month:

DATE(YEAR(TODAY()),MONTH(TODAY()) + 1,1) - 1

Vinay (Salesforce Developers)
Hi Manjeet,

For the first day of the current month:
```DATE(
YEAR(TODAY()),
MONTH(TODAY()),
1
)```

For the last day of the current month:
```DATE(
YEAR(TODAY()),
MONTH(TODAY()) + 1,
1
) - 1```

Please mark as Best Answer so that it can help others in the future.

Thanks,
Malika Pathak 9

Hi Manjeet,

Find the below Solution

First day of the current month:

DATE(YEAR(TODAY()), MONTH(TODAY()),1)

Last day of the current month:

DATE(YEAR(TODAY()),MONTH(TODAY()) + 1,1) - 1