Report

Auto Generate Dates

Ask a question gerry_itac 1Posts Monday April 17, 2017Registration date April 17, 2017 Last seen - Last answered on Apr 20, 2017 at 11:37 AM by TrowaD
Hi All,

I am currently working a excel formula to input a Revision_Date in column A then it will auto generate the number of days per month(only weekdays) on column B(January), column C(February) and so on depending on the current date. Example if today is April 17, 2017 and my input in Column A is Feb 13, 2017, it will compute number of days from Feb 13 to Feb 28 (which is 12 days) to be generated on Column C(Feb). Then on March which is complete since it covers the whole month until today on Column D(Mar). Then comes to April to compute the days from April 1 to April 16 on Column E(Apr). Can someone help me as I am really not familiar with excel. Hoping someone can share any formulas/techniques on how to do it. Thanks in advance.
Helpful
+0
plus moins
Hi Gerry,

Give this a try.

Input data:
A2: 17-2-17
B1: 31-1-17 format as 'mmmm' to display january
C1: 28-2-17 format as 'mmmm' to display as februari
etc. for the other months

Input formula:
B2: =NETWORKDAYS("1-1-17",IF($A2>B$1,B$1,$A2-1))
Drag this formula down and to the right.

B2 should display 22 and C2 should display 12 in this example.

Best regards,
Trowa
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!