Calculate Overun Date

[Flame ifrit]

Hi there clever people,

I am really hoping someone out there can help me out, I have been struggling with this for a while now. Here goes

I have a list of tasks my team needs to carry out on a regular basis. I need to work out the due date for an task to next be carried out based on the date it was last run, the frequency being either weekly, daily or monthly and only working mon-fri.

So I have these columns. Task Name, Date Task Last Run, Frequency.

I need to add another column called "Due Date" that will calculate the expected date the task should next be run on based the frequency, accounting for only a five day workweek where due dates falling on a weekend should roll over to the next available weekday.

I have tried =IF([@Frequency]="Weekly",TODAY()-5 etc.. problem is that's quite crude and I end up due dates falling on the weekends.

 

[Oeldere]

without seeing the data it is difficult to tell (for me at least), but you could incorparate the formula:

day() or week() or month() or year() in your formula.