Article View: comp.sys.mac.apps
Article #9503Re: Excel Day of Month as Value???
From: Charles Corbato
Date: Mon, 14 Dec 1992 14:44
Date: Mon, 14 Dec 1992 14:44
17 lines
1250 bytes
1250 bytes
In article <1992Dec14.023449.1@acfcluster.nyu.edu> mullignj@acfcluster.nyu.edu writes: >I need to know what to do so that a given cell in an Excel worksheet >will have as its value whatever the day of the month it is. > >For example if the date is December 14 I want the value of the cell >to be 14. Etc. > >Is there a way to do this? Try using the function DAY(date). This should do exactly what you want. -- +----------------------------------------------------------------------+ | Charles Corbato Internet: corbato.1@osu.edu or | | Ohio State Univ, Columbus, OH ccorbato@magnus.acs.ohio-state.edu | +----------------------------------------------------------------------+
Technical Details
Message-ID:
<1992Dec14.144434.1225@magnus.acs.ohio-state.edu>Path:
arc1-ca.pugleaf.net!sparky!uunet!zaphod.mps.ohio-state.edu!magnus.acs.ohio-state.edu!ccorbatoReferences:
<1992Dec14.023449.1@acfcluster.nyu.edu>Show Full Headers
Complete Article Headers
Newsgroups: comp.sys.mac.apps Path: arc1-ca.pugleaf.net!sparky!uunet!zaphod.mps.ohio-state.edu!magnus.acs.ohio-state.edu!ccorbato From: ccorbato@magnus.acs.ohio-state.edu (Charles Corbato) Subject: Re: Excel Day of Month as Value??? Message-ID: <1992Dec14.144434.1225@magnus.acs.ohio-state.edu> Sender: news@magnus.acs.ohio-state.edu Nntp-Posting-Host: top.magnus.acs.ohio-state.edu Organization: The Ohio State University References: <1992Dec14.023449.1@acfcluster.nyu.edu> Date: Mon, 14 Dec 1992 14:44:34 GMT Lines: 17