Dynamic start date based on weekday name

[wbstadeli]

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"

 

[awoohaw]

i'm never sure of when the newer functions made it to 365. I thought ISNUMBER is pretty new.

but its been around for a while. I guess i never used it very much in the distant past.

 

[wbstadeli]

Thank you all for your responses, I sure appreciate it!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[snjpverma]

but its been around for a while. I guess i never used it very much in the distant past.

ISNUMBER is a very old function. Seeing it for quite some time now. I think from Excel 2007 version

 

[Fluff]

Pretty sure that ISNUMBER has been around forever, certainly was available in 2003