Hello everyone,
I am completely challenged when it comes to working with Excel, so any help will be appreciated.
My issue is the following: I have a column in which each cell has an integer, I need the integers on each cell to increase by 1 at the beginning of the month. For example, cell value is 5 today, on 12/1/21 it should be 6, and so on until the end of times.
Thanks so much.
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Sorry about that.
Here is the attachment. It only has three columns, the last one, "Number of months active", is the one in which each of the numbers has to increase by one at the beginning of each month.
How to install your new code
Please Login or Register to view this content.
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
To run the Excel VBA code:
- Press Alt-F8 to open the macro list
- Select a macro in the list
- Click the Run button
If you had a start Month/or Date it would be Month(Now()-"start Month" OR Month(Now())-Month("Date") - you might have to take into account year ((Year(Now())-Year("Date"))*12)+(Month(Now()-Month("Date")
If this solves your issue, Mark thread as Solved & Add Reputation.
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks