Hello Everyone,

I am new to the forum and hope that someone will be able to assist me because I have been ripping my hair out for the past hour lol

I have a spreadsheet, my first tab/sheet is titled "1-04 to 1-08"
My goal is to have a CONCATENATE formula in C1 to make a gmail search URL to include the dates from the tab/sheet name.

https://mail.google.com/mail/u/0/#search/after%3A2016%2F01%2F03+before%3A2016%2F01%2F10+-alerts%5D

Please Login or Register  to view this content.
  • CURRENT_YEAR - Need a formula to input current year
  • MONTH_TABNAME(1) - Need formula to input the first month value, but also add a "0" if it is singular
  • DAY_TABNAME(1) - Need formula to input the first day value as it is, but minus 1 day
  • MONTH_TABNAME(2) - Need formula to input the second month value, but also add a "0" if it is singular
  • DAY_TABNAME(2) - Need formula to input the second day value as it is, but add 2 days



I need for it to work in a way that if the day is 01 for, that it knows to go to 30/31 for DAY_TABNAME(1), same as if it is day 30, for it to go to 1 for DAY_TABNAME(2)

This is the query I do in gmail: after:2016/01/03 before:2016/01/10 -alerts]

Hope someone will be able to help me with this, but I am totally stuck.