Creating a time frame

Closed
Annzdurrani Posts 1 Registration date Sunday 21 January 2018 Status Member Last seen 21 January 2018 - 21 Jan 2018 à 04:04
 Blocked Profile - 22 Jan 2018 à 16:55
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.

Thanks,

Ann
Related:

1 response

Blocked Profile
22 Jan 2018 à 16:55
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.