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

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
 
B

Bernie Deitrick

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
 
T

Trevor Shuttleworth

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting to Compare Two Sheets of Data 1
week numbers 3
excel date problem 3
Comparing lists 1
Detemine sales order based on plac changes and not sales figures -mathmatic problem to solve 1
Basic Formula question 6
Auto Sheet Names and Date cells 3
Configuring Dates 1

Top