Calculating Calendar dates from a paritcular date

[kgfklee]

I have a spreadsheet and want to calculate calendar days from a particular date. I thought the EDATE function would do this but it only calculates months. Can someone help me? I would have thought that would be really easy to do. Thanks.

Basically I would like to use the workday function for calendar days.

[daffodil11]

You can use simple subtraction to find the calendar days.

A1: 1/10/2013
B1: 1/19/2013
C1: =B1-A1 which comes out to 9

[amit.wilson]

A simple subtraction should do the trick.

End date - start date = calendar days.

Cheers

[kgfklee]

I do not have an end date. Only a start date. I want to calculate the end date by using the start date and a list which indicated the number of calendar days i want to calculate an end date.

[amit.wilson]

kgfklee,

your message isn't very clear. This is what I understand:

- you have a start date. Assume it is 1Nov13.

- you have a X number of calendar days. Assume X = 10.

You want the end date.

If I have understood the problem correctly, the answer is:

A1: 1 Nov 2013

A2: 10

A3: =A1 + A2

End date in cell A3: 11 Nov 13

Does that work?

Cheers

[kgfklee]

Thanks! This was so simple and worked.