Posted to microsoft.public.excel.worksheet.functions

Mike H

external usenet poster

Posts: 11,501

Sunday

or

=A1-DAY(A1)+CHOOSE(WEEKDAY(A1-DAY(A1)),1,7,6,5,4,3,2)

"Dale" wrote:

This is probably a very basic question so I apologise first, how would I
calculate the last sunday of a given month? Once I have that date, I need
the following Friday......

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find last Sunday	Dean F	Excel Worksheet Functions	5	April 7th 23 12:16 PM
How do I set up 16 team fixtures each Sunday	essexcricket	Excel Worksheet Functions	1	September 8th 06 12:38 PM
Skipping Saturdays and Sunday	John Michl	Charts and Charting in Excel	2	August 23rd 06 03:11 PM
Sunday Function	Sunday Function	Excel Worksheet Functions	3	June 7th 06 08:12 AM
Help with looking the nearest Sunday	JR	Excel Worksheet Functions	6	April 11th 06 03:02 AM

All times are GMT +1. The time now is 05:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us