Conditional date formula

sambaxter

Hi,

I'm having a little trouble creating a formula for a date column. I have a 'Project type' column and a 'Project start date' column which need to determine what the 'Handover to support date' column is.

Basically - for all projects the 'Handover to support date' has to be 1 month after the 'Project start date' apart from 1 specific type of project, where it needs to be 3 months after.

Is it possible to do this? Thanks in advance.

steven.reed14881

Sambaxter,

The following formula seems to achieve what you are looking for:

=IF([Project Type]1 = "Complex", [Start Date]1 + 90, [Start Date]1 + 30)

I am not sure what your project type names are, but in this case, I have named those that require the longer time to handover as Complex. This formula will then give all other project types (if you have more than one) with the shorter, 30 day duration.

I hope this helps!

 

Steve

sambaxter

Thank you so much Steve!

You're a life saver!