Excel tips: Finding the Last Day of a Given Month
Resources

Excel tips: Finding the Last Day of a Given Month

by Khan Mohammad Mahmud Hasan

Excel tips: Finding the Last Day of a Given Month

=DATE(YEAR(TODAY()),MONTH(TODAY())+num_mths,0)

where num_mths = 0 for the end of month for the current month and num_mths = 1 for the end of the month for the next month, etc.
1. Tried the formula if num_months = 0, it gives the end date for the prev

Related posts:

Excel Tips: Entering dates quickly, without having to use delimiters to separate month, day, and year.
Excel Tips: Entering dates quickly, without having to use delimiters to separate month, day, and year.
Excel Tips: Calculating a Date Based on Year, Week Number and Day of the Week
Excel Tips: Calculating a Date Based on Year, Week Number and Day of the Week
Excel Tips: Selecting a random value from a List.
Excel Tips: Selecting a random value from a List.
Excel tips: How to Locate Merged Cells in Microsoft Excel (and then get rid of it)
Excel tips: How to Locate Merged Cells in Microsoft Excel (and then get rid of it)
Back To Top