| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating the last day of the week
Anyone know how to calculate the last day of a calendar week? Assuming
that you have a date in A1, I need to calculate the last day of the week (Sunday is first day), for the week that contains the date in A1. Cheers, Job |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculating the last day of the week
If you have a date in date format in cell A1, in cell A2, put
=A1+6 Did I misunderstand you? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculating the last day of the week
=A1+(7-WEEKDAY(A1))
-- HTH RP (remove nothere from the email address if mailing direct) "Job" wrote in message ... Anyone know how to calculate the last day of a calendar week? Assuming that you have a date in A1, I need to calculate the last day of the week (Sunday is first day), for the week that contains the date in A1. Cheers, Job |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculating the last day of the week
Thanks Bob, this works. Or =A1+7-WEEKDAY(A1)
Cheers "Bob Phillips" wrote in message ... =A1+(7-WEEKDAY(A1)) -- HTH RP (remove nothere from the email address if mailing direct) "Job" wrote in message ... Anyone know how to calculate the last day of a calendar week? Assuming that you have a date in A1, I need to calculate the last day of the week (Sunday is first day), for the week that contains the date in A1. Cheers, Job |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating a week between a range of dates | Excel Discussion (Misc queries) | |||
| Calculating tasks using a six day work week | Excel Discussion (Misc queries) | |||
| Calculating the first day of the week | New Users to Excel | |||
| Calculating days of week | Excel Programming | |||
| Calculating the first day of the week for the month | Excel Programming | |||
Linear Mode
