Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need cell formulas to return the day of every Monday in a month based on year entered | Excel Discussion (Misc queries) | |||
Calculating first/last Monday, Tuesday, etc. in a given month in E | Excel Worksheet Functions | |||
1st Monday of a month in date range?? | Excel Worksheet Functions | |||
Finding the date on the 'nth' Monday in this Month in this Year | Excel Worksheet Functions | |||
Date to a day (Monday, Tue, etc?) | Excel Discussion (Misc queries) |