26 Week chart beginning with Mondays

  • Thread starter Thread starter Frank Kabel
  • Start date Start date
F

Frank Kabel

Hi
enter the following formula for your first Monday
=TODAY()+(WEEKDAY(TODAY())>2)*7-WEEKDAY(TODAY())+2
for all other dates just add 7 to this date
 
Is there a way to create a chart where the date at the first column i
the Monday of THIS WEEK, then the second week starts with Monday o
next week and so on for 26 weeks? So, no matter what day of the week
open the file, the first week starts with last Monday.
I have a chart now but the first day is =NOW(), the second week is +7.
Any help would be appreciate
 
Thank you Frank.
I tried the formula but it gave me next Monday's date. Can I get it t
read last monday
 
Hi
try
=TODAY()+(WEEKDAY(TODAY())>=2)*7-WEEKDAY(TODAY())+2-7

if today is a monday this formula would return today
 
Back
Top