Calendar day not days

[skip]

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)

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Bob Phillips]

Just format it as a date, Format>Cells>Custom and enter say m/d/yyyy

--
HTH

Bob Phillips

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