auto fill value based on frequency

[dani_koentz]

hi,

i need help with excel formula, i am using microsoft 365 on windows.
i have date in row 1 from column C to BD on weekly basis start from monday, but i can extend those in later.
in column B i had my start date.
in column A i had my frequency
so in row 2 and below, and column C until BD will be the result for auto fill text based on frequency and date
you can see in attachment, i do it in manually.
thank you.

 

[Monty]

Hello Dani
You can achieve your desired result, you can use the combination of formulas like IF, WEEKDAY, and TEXT in Excel. Here's how you can do it:

1. In cell B2, you can enter the following formula to get the start date:
`=DATE(YEAR($B$1),MONTH($B$1),DAY($B$1)+7*(ROW()-1))`

2. In cell C2, you can enter the following formula to get the first occurrence based on the frequency:
`=IF(TEXT($B$2,"dddd")=$A2,$B$2,"")`

3. Then, you can drag the formula in C2 across to column BD and down to fill the entire range.

This formula will check if the day of the week matches the frequency in column A, and if it does, it will display the date from column B. If it doesn't match, it will display an empty string ("").

You can adjust the formula based on your specific requirements and date ranges. Make sure to format the cells in column C to BD as date format to display the results correctly.

I hope this helps! Let me know if you need further assistance.