Many thanks. How to Make a Copy of an Excel File (3 Useful Methods), How to Rename Series in Excel (Series, Legends & Axis Titles), How to Copy Excel Sheet into Word (4 Simple Methods), How to Select Every Other Column in Excel (3 Methods). I have seen this somewhere but can seem to find how to do this. Then enter the following formula that uses the NOW function: =NOW ()+30. See the following steps for a better understanding. by Excel processes dates as serial numbers. As for the third method, I want to change the cell colors that contain dates to a particular day, i.e., Sunday. It worked! } as the formula. Jun 25, 2019.