Calendar day not days

  • Thread starter Thread starter skip
  • Start date Start date
S

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)
 
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
 
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)
 
Back
Top