I need to calulate the Date based on Given the following information.
Thursday 17/12/2009 then friday week 25/12/2009 then sunday week.. and so on.
I will be used calculate a promotional time table and need to be accurate.
It has been explained to me that, to make the promotion FAIR to persons attending on a thursday, then those on the Friday and last but not least the Sunday, apparently these date are about 10 or so days appart each time.
So maybe a Formula that looks 19 days from thursday and display the closest friday then 10 days from the friday to display the closest sunday ? Something like that ?
Thanks
Thursday 17/12/2009 then friday week 25/12/2009 then sunday week.. and so on.
I will be used calculate a promotional time table and need to be accurate.
It has been explained to me that, to make the promotion FAIR to persons attending on a thursday, then those on the Friday and last but not least the Sunday, apparently these date are about 10 or so days appart each time.
So maybe a Formula that looks 19 days from thursday and display the closest friday then 10 days from the friday to display the closest sunday ? Something like that ?
Thanks