Need help with date() / month() formula

**mikehk** · 09-08-2017, 09:49 AM

A1 | B1

8-Sep-2017 |

I would like to get a date & month in column B1
example - 8 Oct, next month will be 8 Nov and so on.....it
should change month after month.

Please help.

Thanks.

**Phuocam** · 09-08-2017, 10:04 AM

Try:

=EDATE(A1,1)

**AlKey** · 09-08-2017, 10:04 AM

Enter your date in A1
Enter formula in B1 and drag formula across

Formula:

Please Login or Register  to view this content.

v	A	B	C	D	E	F
1	8-Sep-17	8-Oct-17	8-Nov-17	8-Dec-17	8-Jan-18	8-Feb-18

**mikehk** · 09-09-2017, 01:44 AM

Thank you so much

**mikehk** · 09-09-2017, 01:45 AM

Thank you ...works like a charm!

Need help with date() / month() formula

LinkBack

Thread Tools

Rate This Thread

Display

Need help with date() / month() formula

Re: Need help with date() / month() formula

Re: Need help with date() / month() formula

Re: Need help with date() / month() formula

Re: Need help with date() / month() formula

Thread Information

Users Browsing this Thread

Similar Threads

Formula to give week number of a month according to date of the month

[SOLVED] date formula that puts the first of the prior month based on which month it is

[SOLVED] Need Formula that will show 'Month" for date that fall in the particular month

Formula to change date american (month first) to uk style (month second)

[SOLVED] Formula to return End OF Month date with non-calendar month lengths.

[SOLVED] Date formula with text in same cell but using previous month not current month

Formula to return day based on month end date & day number of month

Bookmarks

Bookmarks

Posting Permissions