How to go "X" number of days out from a undefined date?

M

Max

Hi, I need to create a spreadsheet that will show how many days my team has
to complete multiple tasks. Example I need a formula that will take a
beginning date "X" and add 20 calendar days to it, then display the new date.

Thanks
 
R

Ron Coderre

To Excel, dates are just numbers (actually the count of days since DEC 31,
1899 or since DEC 31, 1903 , depending on your settings). And Times are just
fractions of days (eg Noon is 0.5)

So...if you have a Start Date and you want a date 20 calendar days from that
date....just add 20.

Example:
A1: 01-JAN-2007

B1: =A1+20
Formatted as a date will return 21-JAN-2007

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
M

Max

Yes.

Thank you.



Ron Coderre said:
To Excel, dates are just numbers (actually the count of days since DEC 31,
1899 or since DEC 31, 1903 , depending on your settings). And Times are just
fractions of days (eg Noon is 0.5)

So...if you have a Start Date and you want a date 20 calendar days from that
date....just add 20.

Example:
A1: 01-JAN-2007

B1: =A1+20
Formatted as a date will return 21-JAN-2007

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top