How can I auto populate the start of the week and the end of the week?

[Shauna_Renee]

I’m very new to airtable but have learned a lot by watching tutorials and searching the community. I’m not sure if I’m searching for the right thing for this particular issue though.

I’m setting up an airtable for a client who has a form that needs to be completed by his clients on a weekly basis. He needs to know who hasn’t submitted the form 3 days past the day he sends it out which will be on the same day each week.

For instance, he’ll send the email with the form attached to be completed every Monday and if someone doesn’t fill it out by Thursday, we need to automate an email to follow up and remind them to complete it.

I’m thinking I need a field dedicated to auto-populating whatever the current day is or at least a formula that shows when the week starts and when it ends.

What formula do I need for this? This is literally the last thing I need in order to complete this airtable setup but I can’t figure it out.

Any help would be greatly appreciated!

[Shauna_Renee]

THANK YOU!!! It works!!! Thank you so much!!! I truly appreciate your help with this!!!

[Per_Carlen]

No problem. If I understand your need correctly I think you could just use the formula I gave you initially (pasted below). You want to know if the submission was overdue or not, right?

SWITCH(WEEKDAY({Date Submitted}, "Monday"),
	0, "In time",
	1, "In time",
	2, "In time",
	"Overdue"
)

[mattcperry]

This doesn't work if there is a time in the date field