Home : NWM
Q14662 - INFO: NWM
 NWM returns the Number of Weeks in a Month.

SYNTAX:

NWM(MonthOffset/Date, Weekdef)

MonthOffset/Date: If a number it is the Zero based offset from the Start Date of the report. If this field is a date string (i.e. "07/16/2004") or refers to a cell with a date in it, it sets the month to calculate for

Common values:

0 = Current month
1 = One month after current month
2 = Two months after current month

WeekDef: Defines the week.  IE W7 is  Sunday thru Saturday.   Click here for a table defining weeks and the corresponding values for n. 

 

EXAMPLES:

Start Date of report is March 1st, 2021

=NWM(1,"W7") - Returns 4 as March 2021 has four (4) Sun-Sat Weeks.

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 4/26/2021 5:33 PM.
Last Modified on 4/26/2021 5:33 PM.
Last Modified by Scott Dorner.
Article has been viewed 762 times.
Rated 3 out of 10 based on 2 votes.
Print Article
Email Article