Monday, July 1, 2013

yogi_Determine The Date Of The Last Specified Weekday N (+ or -) Months From Reference Date

                                          Google Spreadsheet   Post  #1264
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 01, 2013
user bobbaz (http://productforums.google.com/forum/?zx=6rcla7maju2x#!category-topic/docs/spreadsheets/WAHFE6fDYj4)
Find the following day of the week
I have searched a bit but I am unable to find a solution....

I am inputting a date (in this case the last day of the month) and want the next cell to provide me the date of the first Thursday of the following month.  Can someone point me in the right direction?

Thanks!
---
Edit:  That should read the last Thursday of the following month
-----------------------------------------------------------------------------------------------------------------------------------------------------
following is a solution for a bit more generalized problem

No comments:

Post a Comment