Hi,
I'm having difficulty trying to achieve what i want. I am making a Monthly Time Card, with a pre-configured 6 week format layout as seen in the picture, however i want the correct date (ex: 8/1/23) to populate correctly to the weekday name based off the month in the "Month/Year" cell. I have a working formula that almost achieves this, however it returns ONLY the day of the month, but I would like it to return the entire date (month/day/year) and then ill just format to display only the day of the month. I need the full date for more coding in the worksheet that uses a date, not just day of month. Here is the current formula that is in the first cell in the list (Week #1, Sunday) and then I autofilled (drag-down) the remaining of that column down to Week 6, Saturday with this formula.
Formula: =IF(MONTH(FLOOR(Start_Date-1,7)+ROWS($E$8:E8))=MONTH(Start_Date),DAY(FLOOR(Start_Date-1,7)+ROWS($E$8:E8)),"")
FYI: E8 is the cell to the right of Week #1, Sunday, "Start_Date" range is the cell that contains the month and year, in this example "August 2023"
I'm having difficulty trying to achieve what i want. I am making a Monthly Time Card, with a pre-configured 6 week format layout as seen in the picture, however i want the correct date (ex: 8/1/23) to populate correctly to the weekday name based off the month in the "Month/Year" cell. I have a working formula that almost achieves this, however it returns ONLY the day of the month, but I would like it to return the entire date (month/day/year) and then ill just format to display only the day of the month. I need the full date for more coding in the worksheet that uses a date, not just day of month. Here is the current formula that is in the first cell in the list (Week #1, Sunday) and then I autofilled (drag-down) the remaining of that column down to Week 6, Saturday with this formula.
Formula: =IF(MONTH(FLOOR(Start_Date-1,7)+ROWS($E$8:E8))=MONTH(Start_Date),DAY(FLOOR(Start_Date-1,7)+ROWS($E$8:E8)),"")
FYI: E8 is the cell to the right of Week #1, Sunday, "Start_Date" range is the cell that contains the month and year, in this example "August 2023"