Selecting dates

Closed

kaake Posts 2 Registration date Monday June 17, 2013 Status Member Last seen July 1, 2013 - Jun 17, 2013 at 02:13 AM
kaake Posts 2 Registration date Monday June 17, 2013 Status Member Last seen July 1, 2013 - Jun 19, 2013 at 12:23 AM

I have a worksheet that list property sales from year 2000 to 2012. I'm trying to mark all property sales into different quarters that is all sales from 1st January to 31st March be marked "1", all sales having date from 1st April to 30th June be "2", all sale between 1st July to 30th September marked "3" and all sales from 1st October to 31st Dec be marked "4"

I got about 5,000 record in my sales worksheet. Please advise

Selecting dates
Mouse pointer not selecting properly - Guide
Defcon dates - Guide
Different dates of "end to end encryption message" on blank chat? - Internet & Social Networks Forum
Vivatech 2024 dates - Guide
Using nested if to blank out adjacent cells - Excel Forum

2 responses

Answer 1 / 2

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jun 17, 2013 at 09:52 PM

suppose data A1 to A6 BS b1 TO b6
hdng1 quarter
1/12/2012 1
4/11/2012 2
7/10/2012 3
10/8/2012 4
1/6/2013 1

FORMLA in B2 is
=ROUNDUP(MONTH(A2)/3,0)
copy it down

Answer 2 / 2

kaake Posts 2 Registration date Monday June 17, 2013 Status Member Last seen July 1, 2013
Jun 19, 2013 at 12:23 AM

Thanks a lot Venkat1926. Problem solved.

Similar discussions

encryption message several time in chat

blank white page for website

IF statements with dates and criteria

using web browser page loads but screen blank

Conditional Formatting - highlight overdue dates

Similar discussions

Subscribe To Our Newsletter!