My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

formula which show last date of the month|General Excel Questions & Answers|Excel Forum|My Online Training Hub

You are here: Home / formula which show last date of the month|General Excel Questions & Answers|Excel Forum|My Online Training Hub
Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
formula which show last date of the month
Avatar
Salim Gul
Member
Members
Level 0
Forum Posts: 37
Member Since:
December 24, 2018
sp_UserOfflineSmall Offline
1
January 25, 2021 - 9:54 pm
sp_Permalink sp_Print

Hi Mynda Treacy 

one of your video, you have teach about the formula of a particular day of the month, =IF(MOD(DAY(G2),30)=0,DAY(G2),"") this is a formula show a particular number of the month, from whole dates, now question is that if i want use only last number of the month, such as Jan last number is 31, while Feb have 28 last day of the month, please guide me about the formula which show end number of the month

regards 

salim

Avatar
Anders Sehlstedt
Eskilstuna, Sweden

VIP
Members


Trusted Members
Level 3
Forum Posts: 930
Member Since:
December 7, 2016
sp_UserOfflineSmall Offline
2
January 26, 2021 - 2:01 am
sp_Permalink sp_Print

Hello,

You can simply use the EOMONTH function for this.

Br,
Anders

Avatar
Salim Gul
Member
Members
Level 0
Forum Posts: 37
Member Since:
December 24, 2018
sp_UserOfflineSmall Offline
3
January 26, 2021 - 4:40 pm
sp_Permalink sp_Print

Hi Sir Anders Sehlstedt 

Thanks for your reply, actually i want a formula which show last date of month in number format, such as 28, 30 and 31, i hope you will easily understand from the sheet of attachment, column C and D guide you what i want. this formula will make easy financial calculation of income of the month. for example income multiply by  number of total days of month.

Avatar
SunnyKow
Puchong, Malaysia

VIP
Members


Trusted Members
Level 8
Forum Posts: 1432
Member Since:
June 25, 2016
sp_UserOfflineSmall Offline
4
January 26, 2021 - 5:59 pm
sp_Permalink sp_Print

Hi Salim

Just use =DAY(EOMONTH(G2,0))

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Saliha Mohamed
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 930
Purfleet: 415
Hans Hallebeek: 355
Frans Visser: 349
David_Ng: 312
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
HMDIGPzunsnLJt lObJcycvbDLCmIq
Stephen Brown
John Kang'ara
iDeYYtyNRPTss icXlxLtkCZaWuY
Elizabeth Kinsey
Shaun Del Toro
Clive Webb
Forum Stats:
Groups: 3
Forums: 25
Topics: 7095
Posts: 31110

 

Member Stats:
Guest Posters: 49
Members: 34532
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen