![]() ![]() So Sheets can dynamically change the background color of the cell when its date value is in the past 7 days. The format rules include three date-related values: date is, date is before, and date is after. This is done thanks to conditional formatting. Today's date is April 25, so this is indicating that we're currently in the week of the 22nd. You'll notice in the previous screenshot that April 22 is highlighted in yellow. Select the timeline cells, go to Format > Number > More formats > More date and time formats., and put only the "Day" chip in the form field. To get the dates to appear only as the day of the month, you can use custom date formatting. Copy F3, select the rest of the row, and select Edit > Paste special > Paste formula only to generate dates for rest of the timeline. So the next week's date will be in F3 and we can generate it by using the formula =E3+7. In the example above, March 4 is in cell E3. ![]() So for our timeline, we can start with a fixed date like March 4 and dynamically create the next week's date by adding 7 to it. What you might not know is that you can apply arithmetic operations on a date, like adding days to a date. So you can enter text like "" and Sheets will understand it to mean Ma(sorry non-Americans). ![]() You probably already know that like most spreadsheet tools, Sheets has native date support. Note: This is based on a template I found in Sheets that I modified to be more dynamic. I wanted to create this post to share a few tricks to build a Gantt chart in Sheets. Google Sheets can be a handy tool for project management. ![]()
0 Comments
Leave a Reply. |