Calendar day not days
 

I am trying to figure a way in which I can add a specified number of
calendar days to a date (ex: 9/21/2006 + 14 days = Calendar date).
I thought it would be an easy thing to do, but when I try what is on
MS help, I get the total days from 1 Jan 1900 and can't figure out how
to convert it to the calendar day.
Can anyone help out in figuring this formula out.

Dan (Still going in circles)

Calendar day not days
 

Dan,

All dates are actually a count of the number of days since 1 Jan 1900 but
are just formatted to look like dates. Try re-formating the number you get
as a date.


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"skip" wrote in message
...
I am trying to figure a way in which I can add a specified number of
calendar days to a date (ex: 9/21/2006 + 14 days = Calendar date).
I thought it would be an easy thing to do, but when I try what is on
MS help, I get the total days from 1 Jan 1900 and can't figure out how
to convert it to the calendar day.
Can anyone help out in figuring this formula out.

Dan (Still going in circles)

Calendar day not days
 

Just format it as a date, FormatCellsCustom and enter say m/d/yyyy

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"skip" wrote in message
...
I am trying to figure a way in which I can add a specified number of
calendar days to a date (ex: 9/21/2006 + 14 days = Calendar date).
I thought it would be an easy thing to do, but when I try what is on
MS help, I get the total days from 1 Jan 1900 and can't figure out how
to convert it to the calendar day.
Can anyone help out in figuring this formula out.

Dan (Still going in circles)