week ending "Sunday" date function

[krislyn]

I would like the date in cell B1 on a weekly timesheet to always be th
previous Sunday's date when I open it. (once a week to update fo
previous week's time) What would the formula be for that?

Thanks
krisly

 

[JE McGimpsey]

Assuming that if you open it on Sunday, you want that day's date, one
way::


=TODAY()-WEEKDAY(TODAY(),2)

 

[Frank Kabel]

Hi
try
=TODAY()-WEEKDAY(TODAY(),2)

 

[Alan]

One way,
=TODAY()-CHOOSE(WEEKDAY(TODAY()),0,1,2,3,4,5,6)
Regards,

 

[krislyn]

A-OK! Thanks for the help!

krislyn;