Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calendar Days and Option Buttons | Excel Discussion (Misc queries) | |||
Generating business days in a calendar month, EXCLUDING holidays | Excel Worksheet Functions | |||
Generating business days in a calendar month, EXCLUDING holidays | Excel Worksheet Functions | |||
how do I make a calendar with every three days a different color . | Excel Discussion (Misc queries) | |||
how do I make a calendar with every three days a different color . | Excel Discussion (Misc queries) |