=if(weekday(Today()) = 2, date+(8*7),"")
format as date
Change 8 to 13 and 26 for your other dates.
if you need it to show these dates for the remainder of the week
=Today()-(weekday(Today())-2)+(8*7)
format as date.
Again, use this formula and change 8 to 13, then 26 for the other dates.
the date would actually advance a week on Sunday.
--
Regards,
Tom Ogilvy
jamie said:
I am creating a spread sheet that with each Monday in a calendar year, I
am needing to multiply 8 weeks, 13 weeks, and 26 weeks out. Please help
