Creating a time frame

Registration date
Sunday January 21, 2018
Last seen
January 21, 2018
- Updated on Jan 21, 2018 at 04:22 AM
 Blocked Profile - Jan 22, 2018 at 04:55 PM
Dear excel gurus/geniuses,
I'm new to excel (as in, new in discovering what a powerful software it is!!)
I want to calculate approximate time (day?)frame for appointments in excel e.g.
If a person came in on 21/01/2018, his next appointment should be within minimum of 3 weeks and maximum of 5 weeks and I would like to make a schedule for a year, so that we can make sure he follows a set schedule.
I can add 21 days to the date in, lets say A2, and tgen 35 days to the date in A3 but now I have 2 dates to create min of 3 wks n max 5 weeks from.
Is there an easy way to do this? Is there a formula that I can apply to the columns?

Desperately need input! Your help will be greatly appreciated.



1 reply

Blocked Profile
Jan 22, 2018 at 04:55 PM
Allocate two separate columns, and label them. Of, if you wish to see them both in the =same cell, it would be:
="1st:" & A1+14 & ", Second: " & A1+35

See if that helps out. BTW, A1 is the date to add to.