Excel expression that would always show the Sunday date of the current week

  • Thread starter Thread starter Rudy
  • Start date Start date
R

Rudy

I would like to build an Excel expression that would
always show the Sunday date of the current week

Based on that date I would like to build a expression that
would fill the date for the Monday of that week

Rudy
 
I would like to build an Excel expression that would
always show the Sunday date of the current week
Click to expand...

If you consider Sunday the first day of the week,

A: =TODAY()-WEEKDAY(TODAY())+1

If you consider it the last day of the week,

B: =TODAY()-WEEKDAY(TODAY())+8

Based on that date I would like to build a expression that
would fill the date for the Monday of that week
Click to expand...

If you consider Sunday the first day of the week,

=A+1

If you consider it the last day of the week,

=B-6
 
Back
Top