| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date problems
I use a worksheet as my subcontractors invoice. the date formulars work fine, though at the moment I change the date within the formular for each new fortnight. Is there a way I can get a pop up prompt or similar where I just type in the date to activate the formular? -- MrEMann ------------------------------------------------------------------------ MrEMann's Profile: http://www.excelforum.com/member.php...o&userid=26625 View this thread: http://www.excelforum.com/showthread...hreadid=399005 |
|
#2
|
|||
|
|||
|
Why not put the date in a cell and refer to the cell in the formula.
Changing the cell is a simple matter once a fortnight, or you could even automate that if there were a rule. -- HTH RP (remove nothere from the email address if mailing direct) "MrEMann" wrote in message ... I use a worksheet as my subcontractors invoice. the date formulars work fine, though at the moment I change the date within the formular for each new fortnight. Is there a way I can get a pop up prompt or similar where I just type in the date to activate the formular? -- MrEMann ------------------------------------------------------------------------ MrEMann's Profile: http://www.excelforum.com/member.php...o&userid=26625 View this thread: http://www.excelforum.com/showthread...hreadid=399005 |
|
#3
|
|||
|
|||
|
I don't understand the question what are you trying to do with the dates -- nijunge ------------------------------------------------------------------------ nijunge's Profile: http://www.excelforum.com/member.php...o&userid=26404 View this thread: http://www.excelforum.com/showthread...hreadid=399005 |
|
#4
|
|||
|
|||
|
Bob Phillips Wrote: Why not put the date in a cell and refer to the cell in the formula. Changing the cell is a simple matter once a fortnight, or you could even automate that if there were a rule. Thanx Bob, I thought that would be the way to go... Have tried to get the formula =DATE(05,06,20) to work in the way tou say, eg. =DATE(H17) but it does not work... what am I doing wrong? -- MrEMann ------------------------------------------------------------------------ MrEMann's Profile: http://www.excelforum.com/member.php...o&userid=26625 View this thread: http://www.excelforum.com/showthread...hreadid=399005 |
|
#5
|
|||
|
|||
|
You don't use DATE in that way. If H17 is already a date, all you need is
=H17. If you have some sort of formula, it would be something like =IF(A110,H1,"") -- HTH RP (remove nothere from the email address if mailing direct) "MrEMann" wrote in message ... Bob Phillips Wrote: Why not put the date in a cell and refer to the cell in the formula. Changing the cell is a simple matter once a fortnight, or you could even automate that if there were a rule. Thanx Bob, I thought that would be the way to go... Have tried to get the formula =DATE(05,06,20) to work in the way tou say, eg. =DATE(H17) but it does not work... what am I doing wrong? -- MrEMann ------------------------------------------------------------------------ MrEMann's Profile: http://www.excelforum.com/member.php...o&userid=26625 View this thread: http://www.excelforum.com/showthread...hreadid=399005 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| search for latest date | Excel Worksheet Functions | |||
| Problems with DATE data type | New Users to Excel | |||
| Problems with date calculations (bank hols etc) | Excel Discussion (Misc queries) | |||
| Date sort problems | Excel Discussion (Misc queries) | |||
Linear Mode
