I need to get week start and week end dates to change automatically

  • Thread starter Thread starter jlyons360
  • Start date Start date
J

jlyons360

I'm trying to get the week start and week end dates to chang
automatically on a time sheet that I am working on. Anybody have
formula?

Joh
 
John,

=INT(NOW()+2-WEEKDAY(NOW()))

will return Monday's date, and

=INT(NOW()+6-WEEKDAY(NOW()))

will return Friday's date.

Format as dates.

HTH,
Bernie
MS Excel MVP
 
John

assuming that you have a date for the first Monday, subsequent Mondays will
be the previous Monday plus 7; the Friday after a Monday will be the Monday
date plus 4. Or am I over simplifying ?

Regards

Trevor
 
Back
Top