Adding to dates without a formula
So, today I discovered that if you are in a date column and type "+1" then it creates a date 1 day from today, and if you type "+15w" it creates a date 15 weeks from now.
If you just type "16w" you get the 16th week of the current calendar year.
What I'd like to do though is be able to type ON TOP of an existing date and have it add to THAT date. I can't find the syntax for this. I've tried "++" and "=+" but these don't work.
It seems odd that the options above are covered but adding to the date in the cell isn't covered.
thanks in advance
Help Article Resources
Check out the Formula Handbook template!