Calendar day not days

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

skip - 22 Sep 2006 21:47 GMT

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)

Reply to this Message

Sandy Mann - 22 Sep 2006 22:11 GMT

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.

Signature

HTH

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

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk

>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).
[quoted text clipped - 4 lines]
>
> Dan (Still going in circles)

Reply to this Message

Bob Phillips - 22 Sep 2006 23:16 GMT

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

Signature

HTH

Bob Phillips

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

> 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).
[quoted text clipped - 4 lines]
>
> Dan (Still going in circles)

Reply to this Message