Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 29th 19, 10:53 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2019
Posts: 1
Default How can i calculate the first sunday of each month

thank you sir its working

  #2   Report Post  
Old January 6th 21, 11:10 AM
Junior Member
 
First recorded activity by ExcelBanter: Dec 2020
Posts: 24
Default how can i calculate the first sunday of each month in excel

The CHOOSE and WEEKDAY functions allow us to craft a formula that returns the first Sunday in a month.
If you type a different month-end date in cell A1, such as 1/31/2015 then cell B3 will return 2/1/2015, as shown in Figure 4. The first Sunday of February 2015 happens to fall on the first of the month.

I hope this helps!
Tim Paine


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How can i calculate the first sunday of each month [email protected] Excel Worksheet Functions 1 July 31st 16 04:30 AM
Second Sunday in the month of May? Charlotte E.[_2_] Excel Programming 5 November 28th 08 03:28 PM
Last day of month is saturday or sunday? Arne Hegefors Excel Programming 2 October 26th 07 10:56 AM
Timesheet Calculate Sunday times that changes every month jeromevw Excel Discussion (Misc queries) 2 May 13th 07 05:07 PM
Date Command to Get the Sunday Before the First of the Month Minitman Excel Worksheet Functions 6 December 2nd 05 10:34 PM


All times are GMT +1. The time now is 09:24 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017