Friday, May 31, 2013

yogi_Compute Date Entry Deadline As First Day Of Second Quarter After The Interview Date

                                          Google Spreadsheet   Post  #1222
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May 31, 2013
user Kim B. (https://productforums.google.com/forum/?hl=en-US#!category-topic/docs/spreadsheets/6FYyWdYzSis)
If command using part of a date
I'm using Google spreadsheet on Chrome/Windows 7.

I have several spreadsheets to track data for a research grant.  I have a column that lists the date an interview was completed in mm/dd/yyyy format entered as text.  I want to create another column with a quarterly data entry deadline based on the interview date.  So, if the interview date is between January 1st and March 31st, the deadline is returned as July 1st of the same year, if the interview date is between April 1st and June 30th, the deadline is returned as October 1st of the same year.  For example, if the interview date is entered as 3/4/2011, the deadline will be returned as 7/1/2011.  If the interview date is entered as 4/13/2013, the deadline will be returned as 10/1/2013.  However, if the interview date is between July 1st and September 30th or October 1st and December 31st, the deadline will be January 1st or April 1st of the next year, respectively.  For example, if the interview date is entered as 9/23/2012, the deadline will be 1/1/2013.

Any ideas on how to accomplish this?

Thanks in advance for any help!

KB
----------------------------------------------------------------------------------------------------