Calculating a date 45 days from Start Date

Katie B

I have a sheet that has a Start Date that is called Start Date #1. I need to create a new date that is 45 days from the Start Date that populates a new column. Can someone help me create a formula to do so. 😏

bisaacs

Hey @Katie B,

You should be able to use this formula:

=[Start Date #1]@row +45

Hope this helps!

Katie B

I inserted =[Start Date #1]@3 +45 into the new column and got #Unparseable. 😏 Does that mean I cannot use "#" If that is true, it makes sense. The @3 represents the row.

bisaacs

Hey @Katie B,

If you're trying to target a specific cell vs a row, you'll need the reference to be:

=[Start Date #1]3 + 45

You would only use the @ sign when you're referencing a row, but not when you are referencing a specific cell.

Katie B

Unfortunately it just doesn't work…I get the following …