All you have to do is copy those formulae down for the other rows. If you can't work it out, attach your workbook and one of us will show you.
All you have to do is copy those formulae down for the other rows. If you can't work it out, attach your workbook and one of us will show you.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Copying formulae is okay, but is there a way to auto-populate the data? for example, if I insert the final date and close out date, the due date and reminders 1-3 will auto general based on a pre-determined formula?
Attached is a sample of my data sets. If you can't see the attachement, please let me know.
Sorry, looking at your sheet I am not clear on the calculations that you want to happen automatically? Can you explain what happens in each of the four cases, please?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks