Calculate the number of days in a month

GoldMine CRM SQL Server QuoteWerks Microsoft Excel Microsoft Word C# Windows XP Microsoft Dynamics CRM HEAT Sage CRM

Calculate the number of days in a month

To calculate the number of days in a month, use the following formula.

=DAY(EOMONTH(C4,0))

Where C4 contains a date within the month you are looking for. The second parameter provides a way of calculating months before or after the cell date you are looking at.

=DAY(EOMONTH(C4,1))
This shows the number of days in the month after the date in cell C4

=DAY(EOMONTH(C4,-1))
This shows the number of days in the month before the date in cell C4

24 August 2009 IB Microsoft Excel

Back To List

Did this article answer your question
	Yes		No

Other items of interest in our knowledgebase

Forced Logout Times

Function to strip HTML from a string

Advanced user settings in XP Home

Rolling events over to the next day

Script to assign table rights to public group

Finding incorrect email addresses

Changing the delay for Record Alerts

Changing the calendar day settings

Changing the VAT rate to 15%

Search our knowledgebase

Note:
Softstuff accepts no responsibility for the use of information contained within this item. No warranties are implied or provided and it is advised that you have a working knowledge of the technologies contained, and we will not be held liable for system downtime, or data loss caused, unless we have specifically advised in writing to you that this is the case during the course of a support issue raised and accepted by us.

Did this article answer your question

Yes

No