Formula - Date Column

RVarner

I would like to add a second date column in my sheet where the Start Date is manually populated and the new Date Column would count backwards 15 working days and automatically populate.  Is this possible?

Thank You,

Roger

Mike Wilday

Yes, make sure the column with the formula is set up as a date formatted column. Then add the following formula. 

=If(Isblank([StartDate Column]1), "Enter Date in Start Date Column", Workday([Start Date Column]1, -15))

Pramod Pawar Krupakar

A add-on question ... I need to send a reminder to a identified email id (populated in adjacent column) based on the equation "Today's Date = Due Date (populated as a either a calculated field or pre-populated date". Can this be done..?

Please let know...

Pramod.

Mike Wilday

Hi, Pramod, 

I do not quite understand the equation you are suggesting. Do you want the reminder to send on the Due date?

If that is the case, you do not need to enter any equation. Just ensure that your email ID column is set up as a contact column. Do this by right-clicking on the column header and choose Column Type.

Then click Alerts > Reminders and set the reminder to the name of your email column, and the date your Due Date column.