G Guest Feb 6, 2004 #1 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
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
T Tom Ogilvy Feb 6, 2004 #2 =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 Click to expand... am needing to multiply 8 weeks, 13 weeks, and 26 weeks out. Please help
=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 Click to expand... am needing to multiply 8 weeks, 13 weeks, and 26 weeks out. Please help
