| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a hand with date calc
Hi,
I'm having a bit of trouble getting this right. A date is entered. I want to know the closest match that is an absoluite week from a starting Date of Dec 30 1939 e.g, say the Date entered is 19 Jan 1940 or 21 Jan 1940 the answer I want is 20 Jan 1940. Any help appreciated Thanks - Kirk |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calc. an anniversary date(50 years) after marriage date in excel | Excel Worksheet Functions | |||
| ND TO CALC FROM ORIG DATE TO NEXT DATE RECEIVED? | Excel Discussion (Misc queries) | |||
| y-axis moves from the left hand side to the right hand side | Excel Discussion (Misc queries) | |||
| y-axis moves from the left hand side to the right hand side! | Charts and Charting in Excel | |||
| calc constant date from variable date & return with ability to rn. | Excel Worksheet Functions | |||
![kirkm[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
