Enter a date based on another date

[Chevon]

I would like help with a formula or rule. I am not great with code.

If I enter a date in cell a1 and it is between January 1 - March 31, in cell b1, I want it to say January 1. If I enter a date in cell a1 and it is between April 1 - June 30, in cell b1, I want it to say April 1. If I enter a date in cell a1 and it is between July 1 - September 30, in cell b1, I want it to say July 1. If I enter a date in cell a1 and it is between October 1 - December 31, in cell b1, I want it to say October 1.

Can anyone help with an easy way to do this? Thanks.

 

[Rick Rothstein]

Give this formula a try...

=IF(A1="","",IF(MONTH(A1)>9,"October",IF(MONTH(A1)>6,"July",IF(MONTH(A1)>3,"April","January"))))

 

[Rick Rothstein]

Give this formula a try...

=IF(A1="","",IF(MONTH(A1)>9,"October",IF(MONTH(A1)>6,"July",IF(MONTH(A1)>3,"April","January"))))

The above formula is the most direct way to write the formula you need; however, if you are into more compact formulas, this will also work...

=LOOKUP(MONTH(A1),{0,4,7,10},{"January","April","July","October"})

 

[DanteAmor]

Try

Excel Workbook
	A	B
1	08-ago	01/07/2019
Sheet

 

[Chevon]

DanteAmor....Your formula did exactly what I was looking for. Thank you.

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.