![]() Easy deploying in your enterprise or organization. The WEEKNUM function is used in Excel to return the week number of a specific date in the year (a number between 1 and 54). The WEEKNUM Function is a DATE and TIME function in Excel. Supports Office / Excel 2007-2021 and 365. Step 2 - WEEKNUM ( (A2-215),1) note: do not use the dollar sign if you'll be pulling the formula down through the entire sheet Cell A2 had the date of, and the formula returned the FY week 15. The WEEKNUM Function returns the week number in a year (1-52).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |