LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 107
Default Date calculation for Monday of one month to the Monday of the next

Morning from a cold SA, sunny but temp is +- 10 deg C

Need to show the dates from the Monday of one month to the Monday of the
next month. This is for a payroll period, thus need to show the dates in
between the two Mondays (i.e Monday 4th June to Monday 2nd July) so that
users can capture the respective hours per employee.

Column B would have the respective dates as per the formula, cell B1 would
have the start date which the data capturer inputs, cell B4 would be the
first Monday of June and then cell B5 would have the Tuesday and then so on
until we reach the 2nd July which is the first monday in the new month,
thereafter the cells should not show any date.

The employees names will be in row 4

Thanks
 
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
Need cell formulas to return the day of every Monday in a month based on year entered mikeburg Excel Discussion (Misc queries) 3 June 14th 06 10:07 PM
Calculating first/last Monday, Tuesday, etc. in a given month in E Rossta Excel Worksheet Functions 3 May 27th 06 02:19 AM
1st Monday of a month in date range?? scwilly Excel Worksheet Functions 22 April 26th 06 04:49 AM
Finding the date on the 'nth' Monday in this Month in this Year agarwaldvk Excel Worksheet Functions 1 April 17th 06 10:53 PM
Date to a day (Monday, Tue, etc?) Taylor Excel Discussion (Misc queries) 4 August 31st 05 10:58 PM


All times are GMT +1. The time now is 04:30 PM.

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

About Us

"It's about Microsoft Excel"