Extract a month from a date and increase by one

[khanaran]

Hi

I am working on a small numerology project

I can extract a a month from the date entered

I am a small isuuewith copy the month for example aug-26

to the next row as Sep-26 and further down as Oct-26

How may I automate this process

kind regards

raj

 

[jtakw]

Hi,

Enter the first 2 dates, then select BOTH cells, then drag down as far as needed:

Book1
	A	B
1	26-Aug	<--Select BOTH cells
2	26-Sep	<--Then drag down
Sheet207

 

[khanaran]

Hi

Thanks for the help

If I were to copy the month and day from one column to another by adding one

How may I do so

 

[jtakw]

You can just do the same, enter two dates in two adjacent columns, select BOTH cells, then drag right:

Book1
	A	B
4	26-Aug	26-Sep
5	Select A4 and B4	Then drag right
Sheet207

 

[khanaran]

Thank you that solved two of my issues

The third one was that i experienced

Aug-26 to Oct 26
Nov-26 to Jan-26

the table has four rows with month day to month day

Regards

raj

 

[jtakw]

Then those are TEXT values, it's going to get a bit more complicated, what do you need done?

 

[khanaran]

I am busy learning numerology and trying to write up an excel spreadsheet to help with the calculation called pinnacles

the 1st pinnacle is from month 1 to month 3
the 2nd Pinnacle is from month 4 to month 6
the 3rd pinnacle is from month 7 to 9
and the 4th pinnacle from month 10 to 12

a pyramid of numbers is used to extract this information and is placed alonside each pinnacle.

I needed the spreadsheet to automatically change the month of each pinnacle period from the extracted month
which becomes the first and continuelike if the date is 2 jun this will be extracted and filles month 1 automatically with a formula. I need the others to be populated automatically

Trust this explanation may help

Regards

raj

 

[jtakw]

I'm finding it a bit difficult to understand what you're wanting a formula to do, can you post a sample of your set up with explanation of what you need the formula to do?

 

[khanaran]

Hi
Sorry for late reply
I was at the clin ic for a small procedure

Will upload my sheet tom morning

rewgards

raj