how to get week number in month in excel ?
how to get week number in month in excel ?
indirectly,
=if(day(date)<8,1,if(day(date)<15,2,if(day(date)<22,3,if(day(date)<29,4,5))))
where date is the date in question
presumably the first seven days are week 1, etc.
not a professional, just trying to assist.....
try this url
http://www.cpearson.com/excel/weeknum.htm
solutions of pracatially all problem have been solved by the MVPs. you have
only do google search.
ikin <[email protected]> wrote in message
news:[email protected]...
> how to get week number in month in excel ?
If you mean the week within the month (i.e., week 1 always starts on
the first of a month), then use =INT((day(x)-1)/7)+1 where x is the XL
date of interest.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <[email protected]>,
[email protected] says...
> how to get week number in month in excel ?
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks