Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
In cell A1 I have date of the month ( eg 14 ) for the 14th day
In cell A2 I have month of the tear (eg 9 or 09) for September In cell As I have the year 2005 the 3 cells would therefore represent the 14th of September 2005 In cell A4 I want....... the 14th september less 72 days to show as dd mm yy (this is where I need help with a formula) The client fills in cells A1 and A2 so they may put 9 or 09, does this present a further problem? thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date Formula | Excel Discussion (Misc queries) | |||
Date formula | Excel Discussion (Misc queries) | |||
Formula to determine a future date based on criteria | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) |