Excel - Macro copy Date for "n" month
Solved/Closed
mama_tracy
Posts
3
Registration date
Friday May 14, 2010
Status
Member
Last seen
May 18, 2010
-
May 16, 2010 at 10:48 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 18, 2010 at 02:41 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 18, 2010 at 02:41 AM
Related:
- Excel - Macro copy Date for "n" month
- Excel date format dd.mm.yyyy - Guide
- Kernel for excel - Download - Backup and recovery
- Macro excel download - Download - Spreadsheets
- Transfer data from one excel worksheet to another automatically - Guide
- Spell number in excel without macro - Guide
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
May 17, 2010 at 05:56 AM
May 17, 2010 at 05:56 AM
See this
https://ccm.net/forum/affich-347407-excel-copy-rows-n-times-with-calculation
It only need slight modification
https://ccm.net/forum/affich-347407-excel-copy-rows-n-times-with-calculation
It only need slight modification
May 18, 2010 at 12:47 AM
May 18, 2010 at 02:41 AM
Other way would be to use CDATE
an other way would be to use formula
with range("C1:C19")
,formulaR1C1 = "=DATE(YEAR(RC2),MONTH(RC2)+1, DAY(RC2))
end with