Hello
We have a spreadsheet set that has three columns of dates, the first column will be entered manually, the next two columns will be formulated to be 7 days after the first date, and then 3 days after the second date.
Can you set these cells to have no information in them unless the first cell is entered manually
The issue I have is that if there is no data in cell 2 and 3 i still have to have a date within these cells as if i delete the cell the formula also is deleted?
hi there. something like this in 2nd column:
=IF(A2="","",A2+7)
3rd column:
=IF(A2="","",B2+3)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Genius!!!!!!!
Is there a way that the 3rd column formula can add 3 workdays instead of 3 standard days
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks